Newbies Adam Robert Posted October 11, 2019 Newbies Share Posted October 11, 2019 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. Link to comment Share on other sites More sharing options...
comment Posted October 14, 2019 Share Posted October 14, 2019 (edited) 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: Can a unit ever have more than two employees? 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, 2019 by comment Link to comment Share on other sites More sharing options...
rwoods Posted October 14, 2019 Share Posted October 14, 2019 I feel a join table coming on! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1664 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now