Hopefully there is an easy answer to this:

My invoices file has a portal that contains client files from a related file. If they have paid, the paid field says "yes", if they have not paid the field says "no".

Let's say I have a client that has not paid for 3 items and those 3 items show in the portal. When they have paid, I would like a script that would change the 3 portal row paid fields from "no" to "yes".

Thanks in advance for you help - sam

FileMaker Version: 6

Platform: Mac OS X Panther

Hi,

Well, from the Invoice file, just use a script that :

GoToRelatedRecords[LineItems-show only]

Perform External Script [set Paid]

GoTo Layout[invoice]

The "Set Paid" script in the Line Item would

Go To Record[First]

Loop

SetField[PaidFlag,"Paid"]

Go To Record[Next-exit after last]

End Loop

If this is not a shared environment, you could just use a lookup field and a Relookup script when you reached the LineItems through the GoTo Related Records.

FileMaker Version: 6

Platform: Mac OS 9