I'm new to Filemaker and jumping in head first.
I have a workorder table and a personnel table with a many to many relationship.
I want to select a specific person to add to a specific field to display on the work order layout.
I have a requestor and assignee for each work order.
I could just add the requestor and assignee fields to the workorder table but that would duplicate the data between the tables.
Would I create a join table for the requestor and relate it to both workorder and personnel then create a copy of the workorder and personnel tables and add a new join table for assignee linked to the copies?
Is there a better way to accomplish this?