MattLeach

Relationship Quandry

Discussion created by MattLeach on Feb 10, 2012
Latest reply on Feb 11, 2012 by jamit24

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.

Outcomes