Change Relationship

[Wizard Systems]

I have a FMP v7 with several files.

The relationship to the parent file is on a Name in a text field.

I want to add a field "Client#" in each file and base the relationship on that such that the Name can be changed in the future without affecting the relationships.

How would I populate the new Client# field without manually editing all the records? I would want then set up the client# to add the next client# automatically for each new record.

TIA

Jim

[transpower]

You would need to use two loops in a script. Loop over all records of the parent file; set a field in the parent record to the next serial number; inside the first loop, loop over the child file; for each record, add the new serial number.