Need help developing a Script
It looks like there is a great amount of help here, and I am hoping that I will be able to receive some great advice.
I have database with some 6000+ unique records. Many of these records are related by a field I will call "ID".
All records with the same "ID" must also have the same information in the field I will call "Link".
I am hoping to make a script that will do the following:
Go through my entire database and search for all records that have an entry in the field "Link" (some are blank), and then to copy and paste that Value of the "Link" field into ALL other records that have the same "ID".
I am having a lot of trouble trying to come up with something. Please let me know if I need to be more specific or if you have questions! Thank you for your help. I am running on Filemaker Pro 9.0v3