Table design question

[Guest]

I helped someone develop an access DB to store info about their suppliers and
distribution process.

This is what I have,
One table that defines the suppliers of bottles (SUPPLIER), A table that
defines each type of bottle(TYPE) and another table that defines the plant
where these bottles are filled(FILLING)

I then included a linking table that joins the supplier, the type of bottle
and the location of the plant where they are filled. This linking table has
3 fields. I made the supplier and type fields a multi-field primary key and
also included the Filling ID field.

Problem is, now I realize I may have times when the primary key may need to
be duplicated, that is the supplier and type combo can appear more than once
because there are times when the . What would be the best way to correct
this? I am thinking I may need to recreate the table with the supplier and
type using an autonumber field as the primary and a new table that includes
the new ID and the filling location. Am I on the right track? Any help
would be greatly appreciated.
Thanks
Vicky

 

[Guest]

Yes, you are on the right track.

Dorian.