adding records to linked tables

[Guest]

Background:
I have a table Winners [WinnerID, PlayerID, AwardID] that store the award
winners from the Players table and the Awards table. I use autonumbers in
Awards and Players as the primary key and not the name of the player or the
name of the award. So, my Winners table has records of [1, 5] which means
player 1 earned award 5.

Question:
How do I set up a form to add/delete records to the Winners database so that
the user *sees* the player name and award name(not the PlayerID and AwardID),
yet the database adds/deletes the PlayerID and the AwardID? Is there a flaw
in the design?

Thanks.

 

[Allen Browne]

1. Create a form bound to the Winners table.

2. In the form add a combo box with these properties:
Name PlayerID
Control Source PlayerID
Row Source Players
Bound Column 1
Column Count 2
Column Widths 0
This assumes that the first field in your players table is PlayerID, and the
2nd field is the one you want to show.

3. Do the same kind of thing for the AwardID field.

You can add the combo from the Toolbox. (View menu if you don't see it.)