AnsweredAssumed Answered

Moving to specified field in a portal after data entry... possible?

Question asked by synergy46 on Dec 18, 2013
Latest reply on Dec 20, 2013 by synergy46

Title

Moving to specified field in a portal after data entry... possible?

Post

     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.

     The problem:

     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?

      

      

Outcomes