AnsweredAssumed Answered

Relationship help needed - Many to One

Question asked by jacksrmd on Sep 11, 2013
Latest reply on Sep 11, 2013 by jacksrmd

Title

Relationship help needed - Many to One

Post

     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.

Outcomes