craigf@demoservices.com

Transfer field infomation from one table to another

Discussion created by craigf@demoservices.com on Dec 29, 2015
Latest reply on Dec 29, 2015 by craigf@demoservices.com

Hello,

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,

 

Craig

FMP 14

Windows 10

Outcomes