I have a database that tracks information on our portfolio of rental properties. The database is hosted on a filemaker 15 server and I work off of filemaker 15 advanced.
The Problem: I have a main development table named "Development" and a related welfare exemption table named "Tbl_WelfareExemption". I have a tabbed layout based on the Development table with one tab that contains portal rows to the related welfare exemption table. I have a button that performs a script to automatically add new welfare records to the portal rows for each development that requires a welfare exemption. My script works fine when I first run it, but when I subsequently run the script, it seems to overwrite or delete the portal row records that I previously added through the script rather than just adding new portal records.
Here is a link to a short movie which details the issue:
Also, here is the script that I made to perform this addition to the portal records:
Any help anyone could provide would be greatly appreciated!