Which Player on which Card?

[CribbsStyle]

OK, Here's the tables I have setup...

Cards
------------
CardID

Players
------------
PlayerID
FirstName
LastName

PlayersonCard
-----------
CardID
PlayerID

I have a form setup that has a combo box for Player Name, and several
other options for the sports card.

How do I link these all together so I know which player is on which
card?
How would my combo box be setup?
If a card had multiple players, how would I set this up?

I am pretty new to all of this, dont understand the whole subform
thing, so please bear with me, and dumb down the explanation the best
that you can.

Now John W. Vinson has been helping me, and please John if you are
around, more help would be greatly appreciated.

Thanks!

 

[Douglas J. Steele]

Typically you'd use a form/subform setup.

The form would be bound to the Cards table, and the subform bound to the
PlayersonCard table, with the LinkMasterFields/LinkChildFields properties of
the subform control linking the form to the subform through the CardID
field. The PlayerId field on the subform would be bound to a combo box, with
its RowSource based on the Players table.

Take a look in the Northwinds sample database that comes with Access. Your
set up is similar to that of the Orders, Products and Order Details tables.
The data for those tables is maintained through the Orders form, which uses
the Orders Subform form as a subform.