13 Replies Latest reply on Feb 11, 2012 4:37 PM by jamit24

    Relationship Quandry

    MattLeach

      I'm in the middle of setting up a database and am stumped on how to accomplish a relationship. Figured i would post here so that it gets done the correct way from the beginning.

       

      The database contains 4 tables:

      Transactions

      Properties

      Companies

      Loans

       

      The Transactions table is the main table.

       

      Each transaction can have one or many properties

      Each transaction can have one or many loans

       

      Each property can be tied to many transactions

      Each company can be tied to many transactions

       

      Each table has a primary key that is named as pk_(tablename)ID

       

      Im not quite sure how to setup this relationship. Most databases i've worked on until now have been a 1 to 1 relationship opposed to one to many.

       

      Any assistance would be appreciated.