Question : How to keep a Portal in sync with a main table.
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.