3 Replies Latest reply on Sep 13, 2011 9:01 AM by philmodjunk

    Question : How to keep a Portal in sync with a main table.

    BillyWilliams

      Title

      Question : How to keep a Portal in sync with a main table.

      Post

      Hello,

      I am learning FMP, step by step, very slowly.

      Its taken me all day to get to the stage shown below, and now I need a bit more help.

      I have one table tblStudent, which has been Self-Joined.

      The Layout has a Portal on the right.

      I need the main layout record and the portal record to be in sync.

      So when the main record changes, the portal record is highlighted.

      I tried a whole host of script combinations, using On Events.

      I've learnt a lot about scripts, but not enough to get a result.

      The closest I got was to have the portal record highlighted, but it was always either one record behind or in advance of the main record.

      I hope all that made some sort of sense, I'm going to plug away at this until it works.

      Thanks.

       

      layout02.jpg