AnsweredAssumed Answered

Many to Many relationship

Question asked by paulscholz on Dec 22, 2017
Latest reply on Dec 28, 2017 by philmodjunk

HI all,

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?