Background:
I have a table call tblTeams. In it i have Player1ID & Player2ID. The IDs stored in tblTeams come from table tblPlayers and each ID is unique in tblPlayers.
In tblTeams records are created by selecting 2 players from tblPlayers. Each record in tblTeams is unique
tblTeams fields...