Is it possible to create a three-way many-to-many relationship? If so, how would you tackle this? I'm thinking of employees, positions (or billets), and position titles. Some employees over time move to and hold new positions, but you don't want to delete the person's historical records. Thus, in your database one employee may hold multiple positions over time. Also, you often have situations where the new incoming employee holds the same position as the outgoing employee, overlapping for a time during a handover period, meaning you technically have two persons in the same position at the same time. Lastly, position titles are often shared across positions and employees. I see multiple relationships in three directions here. How can you set this up? --Kent J.
Abraham Breuer
@Reply 3 years ago
Make a EmployeeHistoryT
-ID
-EmployeeID (Foreign Key)
-PossitionID (HelperT)
-DateStartedThisPossition
-DateEnededThisPosittion
to quick up stuff you can use VBA to change a field in the EmployeeT "CurrentPossitionID" to the current Possition
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 7.