I have field BALL in tblPLAY for which I want to input data based on a lookup list.
The structure of tblPLAY looks like this
PLAYID...GAMEID...BALL...
The field GAMEID is the primary key in a second table called tblGAMES which looks like this
GAMEID...TEAM1...TEAM2
For each record, I...