Set Field script in repeating fields
I have a database used for project management. Each project have sites that do the work. Projects have multiple sites and sites can be related to multiple projects. To deal with this I have a repeating field in the SITES table for project numbers. This has allowed me to assigned sites to numerous projects.
I am writing a script to be used in the layout for the PROJECTS table for the purpose of assigning existing sites to the project. I want to use the Set Field command to set the appropriate data in the field for the project id (which is the repeating field). The field sets properly but always into the first of the repeating fields. Is there a way to make the Set Field command populate the next empty field?