Moving to specified field in a portal after data entry... possible?
I am using FM 12 04 Advanced on Windows.
I have a portal called Dues. It is related one to many with Members.
The fields on Dues are:
Date (Calendar Date)
MembershipYear (calculated by script and inserted according to what Date was entered)
AmountPaid (Numeric field)
Dues portal is natively sorted DESCENDING on MemershipYear then by Date.
For example, there are 2 entries in the portal
Dec 31, 2013 2015 $200
Dec01,2013 2014 $150
...I enter Dec 15, 2013 in the bottom row of the portal. If I commit the record, it sorts to the 'between' position. And, even if I use GO TO Field (AmountPaid), FM can not go to the correct portal row because the CommitRecord has sorted the Dec 15 portal row and I have no way for my script to find the correct row number of the new portal row position. (If I use Get(ActivePortalRow) it will show 3; the bottom row).
I KNOW I am over looking something ... Can you help?