Good morning FileMakers.
I know this question has been posted before, but I thought since some of the new data features with 17 and the growth of JSON, I thought I would ask it again.
What is the best way to transfer a small set of records (less than 25) from one table to another?
My use case is for a laboratory supply shipping system for science class experiments.
When creating an order ( LAB_ORDER table ) the user can select from a series of Labs (LAB table ). Each Lab ( e.g. Clean Smoke Test ) has a series of items (LAB_ITEM table ) that have already been assigned to it. I need to transfer a set of LAB_ITEM for the specific lab to the LAB_ORDER. It would be nice to transfer several fields, but really all I need is ID for each of the LAB_ITEM records.
Let me know what additional information you may need regarding my use case.