Transfer field infomation from one table to another

Discussion created by on Dec 29, 2015
Latest reply on Dec 29, 2015 by


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