Newbie question - data entry form for team/match players
Essentially I am converting my database from OooBase (previously MSaccess) and want to mimic a form/subform combination that I use for data entry.
I have 3 tables:
which has the fields 'gameid', 'MatchDate', 'Opponents', 'PtsFor', 'PtsAgainst',...etc
Which has the fields 'playerID', 'Firstname', 'Lastname',.. etc
Which links the 2 tables and so has the fields:
'gpID', 'gameid', 'playerID', 'goalsscored', etc...
My end result is to have a form which allows me to enter the Game details and a subform to enter the players for that game.
My question regards - what is the best way to lookup and enter the list of players ?
Thanks in advance for any design suggestions.