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:
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.