I have two tables. tblContacts and tblTeams.
Each record in tblTeam has 3 contacts. And I use a drop down to populate the ContactID from the tblContacts table in each of those 3 team contacts.
So the tblTeams table looks like this:
TeamID, Team1, Team2, Team3
01, 02, 03, 04 (These are the ContactID from the tblContacts)
02, 02, 04, 05
03, 05, 07, 08
04, 03, 04, 08
Notice that one ContactID can be in several teams - there is no pattern.
The problem I'm having is trying to populate the names from the tblContacts in a query instead of just displaying the ContactID.
Any ideas?
Each record in tblTeam has 3 contacts. And I use a drop down to populate the ContactID from the tblContacts table in each of those 3 team contacts.
So the tblTeams table looks like this:
TeamID, Team1, Team2, Team3
01, 02, 03, 04 (These are the ContactID from the tblContacts)
02, 02, 04, 05
03, 05, 07, 08
04, 03, 04, 08
Notice that one ContactID can be in several teams - there is no pattern.
The problem I'm having is trying to populate the names from the tblContacts in a query instead of just displaying the ContactID.
Any ideas?