Need Help With Filemaker Script
Hello, I am currently working on a script to update patient records. The way it is set up is that in Layout 1, there are patient records. In Layout 2 (Changes), there are about 50 patient records that have updated information. For example, "Amy" in Layout 1 has an account number of 10. In Layout 2, there are 4 Fields. "If data 1" contains the name of a field in Layout 1, such as account number, to match information up to make sure the record that needs to be changed matches the one in the server. "Equals data 1" would then be the account number of the patient record that needs to be updated. If the two match up, it would change the data. "Field to change" would specify what field in Layout 1 needs to be changed (ie. account number), and "Change to" would specify what to change that field. So if we ran the script, it would find all of the changes that I put in Layout 2, with "If data 1" "Equals data 1" "Field to change" "Change to" and it would go through all the patient records and update them accordingly. I have tried a couple of solutions. My first thought was to have a nested loop. It successfully pulls the data and matches a single file, but there are many problems. It should work, but simply does not. I would love some suggestions. I included a picture of the script below.