Search data and create new record if needed
I have a database that is imports data on a weekly basis. the data relates to individuals within a group, however the individuals providing data can change on a weekly basis. is there a way that i can script so that FMP searches and finds when a new individual provides data and then creates a related record for that individual in another table. This record is used as a summary page of the data that is collected from that individual. At this stage i have the individuals info table with information that has been manually entered related to the data import table (this currently works fine in bringing information across) but cannot work out how i can set it up so that it works "automatically" or by pressing a button to run a script.