cant goto correct field

[jhomer]

ARG!

i cant seem to get this script to work correctly.

I have a solution which includes a layout. Essentially what it is A master order layout with a protal into production orders. Each production order ads an 01..02 ext sequential number to the master order. thus a master order of 1234 becomes 123401 and then 123402 as you add more production runs of that same order.

In the begining i was having problems with users not commiting the record becuase they were tabbing through the layout. So i added a script that commits the record when you click on a field and then takes you back to that field..however in the portal it will always take you to the first occurance of that field in the portal and note the subsiquent records.

i tried a goto last record however that doesnt work any ideas as to how i can commit the record and have the curser goto the new record in the portal?

any help is greatly appreciated

[mr_vodka]

You may be able to, once the new portal record is created, set a global field to capture the portal row number using, Get ( PortalRowNumber ). Then afterwards, you can use Go to Portal Row () with the number you captured in the global field.

[jhomer]

ahhh and in that lies my real problem

i need to create a new record in the portal. there is only one data entry field on the portal. is there someway to create a new record in the portal via a script.

[mr_vodka]

I personally dont like creating new related records by using a portal. Instead I tend to use global fields to allow users to type their info into, and then have a button that runs a script to create a new related record for me, populated with the data from the global fields.

Otherwise you can use the 'Allow creation of records' in the relationship definition to have that blank enterable record at the end of the last record in the portal.

Personal preference.