9 Replies Latest reply on Jan 21, 2016 11:59 AM by synergy46

    FM 14 Portal Row Determination

    synergy46

      I have a membership application.  There is a 'many' portal named DES that holds the member's Status:  Deceased, Demit, Suspended etc....

       

      DES: has two fields:  Type (Deceased, Demit, Suspended) and Date.

       

      The portal sorts onDES::Date descending.

       

      Logically the 'Deceased' type would be the latest date for the portal.

       

      My problem is coming up with some error checking that works.  I need to check if a member has entered, for example,  a Suspended Date of Jan 5, 2016 and then entered a Deceased Date of Dec 22, 2015  (A member can not be suspended after they die).

      I have tried setting $Type=DES::Type and $PortalRowNum=get(ActivePortalRow) to capture the row of  the most recent entry.

       

      But, after the Commit, the portal resorts and get(ActivePortalRow) = 0 and of course the Deceased row may be moved somewhere else.  ..... Even if I use it AFTER the Commit.... (Why does commit 'break' any subsequent use of get(ActivePortalRow)?

       

      Everything pretty much works EXCEPT that after the Commit, I need to 'find' the 'Deceased' DES::Type and delete the DES::Date and since the portal rows are changed and get(ActivePortalRow)=0 I can't find (if it exists) the Deceased row....

       

      Ideas?

      DESType.png