Relationship help needed - Many to One
I have 4 tables: App, Reimb, EE, and ARE
-ARE is the join table that has
__kf_App# and __kf_EE# that joins to App table ( __kp_App# and __kf_EE# )
__kf_Reimb# and __kf_EE# that joins to Reimb table ( __kp_Reimb# and __kf_EE# )
__kf_EE# that joins to EE table ( __kp_EE# )
-EE table is the employee table and __kp_EE# = Employee ID Number (unique)
Many Applications (App) can be created for an employee (EE).
Many Reimbursements (Reimb) can be created for an employee (EE).
But since an Employee (EE) is one person and the __kp_EE# is unique within EE,
How should the relationship be set up so that I don't get a unique error when a new case is created in App and/or Reimb for an employee # that has been entered before?
Thanks in advance.