Relationship Problem.....in Access

[rkazmerik]

Hello,

I am having a bit of troubles in my design conceptualization i believe. I am building a database to keep track of a companies liabilities....therefore i have several liabilities that all belong to one company. I have one table that is called 'client information' that lists the corporation name which i have identified as the primary key. My other table is called 'liabilites' and i also have a corporation field in that table but i can not define it as the primary key because i want to have several payments under one company.

How should i set up my tables and relationships?

Any help is greatly appreciated.

Thanks

 

[dcobau]

1) Add an ID field (usually autonumber) as the primary key in tblCompanies (eg CompID).
2) Add another autonumber key in tblLiabilities (eg RecID) as well as CompID. The first is to identify a unique record, the second to link the record in tblLiabilities to the relevant record in tblCompanies.
3) Set up a relationship one====>many (tblCompanies====>tblLiabilities).

Dave