Main Form - Sub Form

[Jenny Lee via AccessMonster.com]

Hi,

I have a main form called consignment and a subform called Artwork subform
They are linked via consignID, The problem is that if I have more than one
record in the Artwork subform I end up with as many consignment records.
This doesnt make sense to me because the parent table contains consignID
which is the primary key. so why then does it allow me to have several
records with the same consignID??? Am I missing something here??? (Maybe a
few marbles)

Cheers
Jen

 

[Larry Linson]

If there can be, as I'd expect, more than one piece of artwork in a
consignment, the main and subforms need to be linked by ConsignID, but the
Subform should include a Field into which an ArtworkID field will be stored
(either manually or via code).

Description of the Forms is not enough to determine your data storage
details. If my comments above are insufficient, please post back here with
clarification, and perhaps someone will be able to offer more specific
advice.

Larry Linson
Microsoft Access MVP

 

[Jenny Lee via AccessMonster.com]

The main form and the subform are linked via consignID and the Artwork
subform does contain ArtworkID. Yes this is a one to many relationship.

ConsignID is the primary key on the main form and consignID is the foreign
key on the subform. ArtworkID is the primary key on the Artwork subform.

I cannot work this one out!!!

Cheers
jen