AnsweredAssumed Answered

Small Data Transfer Between Tables

Question asked by sam.gedert on Sep 20, 2018
Latest reply on Sep 20, 2018 by philmodjunk

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.