Hi I am very new to file maker and I need help.  I have to tables I am trying to connect.  One table has employee information including employee number, name, etc.  The other is a table where two employees make up a team or "unit". On the Unit table I have employee #1 and #2.  I am trying to figure out how to be able to relate each employee to the Personnel table.  I have a feeling this is a very basic question.  Any help is greatly appreciate!  

 

Here is a screen shot of the tables I have set up now. Only employee #1 can see info on the personnel table.

On 10/11/2019 at 7:33 PM, Adam Robert said:

I have a feeling this is a very basic question.

Actually, it's not as basic as it would seem. There are several ways you could look at this. But first, let's understand the exact situation you're tracking:

1. Can a unit ever have more than two employees?
2. Can an employee belong to more than one unit? (Even if not, would you want to keep a history of employee's membership in a unit, in case they're reassigned?) 

Edited October 14, 20197 yr by comment

I feel a join table coming on!