I’m trying to develop an Access 2010 database that will add two members to a team and keep track of their stats. The tables I’ve created so far are tblPlayers, tblTeams, and tblTransactions. I was thinking about using a horizontal tab structure with one tab for each team member and one for the team information.
The PlayerID (from tblPlayers) for two Players must exist before a record in tblTeams is created because it requires two members.
Does anyone have any suggestions for me? thank you very much.