Portal data entry and refresh issue
I'm using a portal in a popover to allow end users to enter data direct to the main data set. Existing data already exists in the child table the portal is based on and some calculations pull this data through based on certain criteria.
The problem for me arises when adding a new record to the child data set. As you click the bottom (blank) row in the portal, the values from the above records disappear from the screen, although the rows, descriptions etc that they're associated with stay.
I've tried script triggers on entry of the first field of the first record to refresh portals which seems to work, but this doesn't place the entry cursor where it should be. I have no idea where it goes, but I have to re-click into the first entry field, which is no good.
How can I either prevent these calculated values vanishing when I create a new record (I've not seen this behaviour in other areas of the system) or how can I get the focus back onto a specific field on the new record?