Jump to content
Salesforce and other SMB Solutions are coming soon. ×

save record to different table


Recommended Posts



I feel as if I am overlooking something, since there clearly has to be either a join or a script functionality doing this:


I have a one record table (lookup_table) and, upon changes made to that one record, would like the record be be saved to a different table (list_table). So, after three changes made to that record, there would be three records in the other table (list_table), and still only one record in the original table (lookup_table).


I have tried joins, lookups, calculations, and copy scripts, but nothing works.

It might not work because the contents of the original table (lookup_table) are 90 percent looked up themselves,as the name indicates. But I merely want to copy the content of that one record to another table and save it there.




P.S.: My last two postings were already hinting at this problem, but since the suggestions I received did not work for my file, here I am again, this time left with this one problem only (after which I am done with my very first working Filemaker file, yay).

Link to comment
Share on other sites

By the way, I thought that once I find out how to solve this problem, I can easily compare the one record from lookup_table against all records in list_table, should there be any, in order to update any outdated records. This should be smooth sailing, since I am using a keyfield for both tables.

Link to comment
Share on other sites

  • 4 months later...


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use