I've just returned to using Filemaker, so my knowledge is a little dusty.
I have a file storing data about all of the companies we deal with. Within a layout, I have a portal listing all employees of the company. I also have a button to create a new employee in that company. The employees are related to the company using a company ID code.
In the past, I have had a script which copies the company ID code, opens the Employee file, and runs a script in the Employee file which pastes the company ID. I now know this is bad practice. It did seem a little inelegant.
I have been told that you should use global fields. I assume that you are supposed to store the company ID in the global field during the process. I am worried that two users might create new employees simultaneously and one user might replace the value of the global field before the other has completed the process.
Is there anyone willing to enlighten me?