December 2, 200421 yr 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
December 2, 200421 yr 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.
Create an account or sign in to comment