Form to Pick Team Members From Access DB Tables

[DBA-Meister]

I have recently become the ScoreKeeper for a "couples" dart group. Each week, every player is randomly assigned to a two-person team. A team is eliminated after two losses. Winners keep playing unti there is only one team without two losses.
I have an access db with several queries and these tables:
Players: ID, Name
MatchDates: Match-Number, Cal-Date
Scores: Match-Number, ID, Score [ Player-ID ]; a player can have multiple scores in each week ]
Teams: Match-Number, ID-1, ID-2 [ Match ID's ]
MatchUps: Match-Nmbr, ID-1, ID-2 [ Team ID's ]
I have quite a bit of dba experience, but very little form experience. I want to create one (or more) forms to:
1. Pick the team-members for each team
2. Pick the team matchups
By "Pick", I mean in each case, I would like to see a (scrollable) list of choices that let's me click on one "name" at a time until two have been chosen and then have the corresponding ID inserted into the table. It would also be nice if already selected entries are removed from the next "pick".


If anyone has already done something like this, you could save me a lot of trouble. Thanks in advance.

[June7]

A combobox or listbox listing players is easy. Making selected players not show is rather tricky but can be done. Requires a query that includes the Players and Teams tables and applies criteria of Is Null under the Teams table ID-1 and ID-2 fields . Never tried this where there would be two fields to check.

[Ruegen]

You could work backwards.

Have a field in each team that holds a number value

Have a table of matches

When you create new match, the players in the list receive the ID of the match and because their field is no longer null (or equal to the same ID) - they are then removed from the list...

Depends if you have quarter finals too..

This way you can date matches and have as many as you like (so match one is on date one and time one) so each match between teams is separate.

I'd have a button that makes a new match record, then when you click in the list it "hides" the players when at the same time is putting a ID number of the match in their new number field....

If you want to keep records in the match you would need to probably make fields for each (winner, loser, score etc) .. or use a many to many relationship to have more than two people join the same match.

[DBA-Meister]

I would like a form that has three "panes". The first two panes would each show a scrollable list of the names of unpicked players. When a player has been picked from each pane, a row would be created in the MatchUps table with the current week number in Col. 1 and the ID of each of the two players picked in the columns two and three. The enitre (scrollable) MatchUps table would be visible in the third pane. I am a novice with forms and panes. Should I use a combo-box for all three panes? Or is there some better way to do this?