Composite Key

[stehamp]

View attachment relationship.doc

I have attached the above relationship diagram as I am having a few problems with a table that uses composite keys to link to 2 other tables. The table is called subsmag and contains the fields subid and magid to link to the subscriptions (subid) and magazine (magid) tables. Basically 1 subscription can have many magazines and I am using the subsmag table to link the 2 tables. When I try to enter data in a form it doesn't like the composite key. Can anyone help, I have inherited the database design and I'm thinking it needs a redesign.

thanks

 

[KeithG]

What error are you receiving? SubID and MagID look like Foreign keys to Subscriptions and Magazines.

 

[RuralGuy]

The table is simply used to join a many:many relationship. I believe it is unnecesary to have the composit key in place. Simply remove the key from the table and things should start working as you would expect them to.