AnsweredAssumed Answered

Problem with script to add portal row records

Question asked by RobFredericks on Sep 10, 2016
Latest reply on Sep 10, 2016 by RobFredericks

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:


Issue with script to add Portal Records - RobFredericks's library


Also, here is the script that I made to perform this addition to the portal records:



Screen Shot 2016-09-10 at 1.28.00 PM.png


Any help anyone could provide would be greatly appreciated!