2 Replies Latest reply on Dec 29, 2015 12:44 PM by craigf@demoservices.com

    Transfer field infomation from one table to another



      Its been a few years since I've used FMP and I know there is question has most likely been answered by I can not seem to find it.

      But here is what I am looking to do:


      I have a table with all my contact information. I have a second table for creating estimates. When I enter the ContactID in the the Estimate Table, I'd like to copy over the contact information such as Name, Company, Phone, etc. I don't want to link the information.

      I know I can wight a script to simply copy and paste but I remember that was not the best way. 

      I assume I will use a script when when I exit the ContactID field to trigger the transfer.


      Thanks for the help,



      FMP 14

      Windows 10