AnsweredAssumed Answered

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

Question asked by BillyWilliams on Sep 11, 2011
Latest reply on Sep 13, 2011 by philmodjunk

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

Outcomes