5 Replies Latest reply on Sep 11, 2013 2:25 PM by jacksrmd

    Relationship help needed - Many to One

    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.