I am not an experienced user of Filemaker since I have few months using it. I have different files such as clients, invoices, etc. so I would like to copy or search for data from the other files. For example. I would like to find the client ID, or name from the invoices file; or copy them from one file into the other. I have been using copy and paste to accomplish this task, but I know it is not the best way to do it.
What would be the best way to do it? Which script could I use?