Use script to open layout to take new record inserting primary key information in the layout.
Posted on 2006-10-23
I am trying to develop a script to create a related new record in a layout (Employer) and automatically insert primary key field information from layout (Contact) into a foreign key field in the new record in the Employer layout. This is a very common step in other databases such as Access so I am sure there is a simple method or example of how to do this in Filemaker Pro to which I am a relative newcomer. I experimented with:
Go to Layout ["Employment"(Employment)]
Set Field .....its is here that I am failing to get the fields matched up. What do I put
Commit Record/Requests [No Dialog]
I can see me using this step all the time throughout my databases so any suggestions would be appreciated.