Different fields from a single table

[Evil6]

I'm building a db to keep record of basketball games.

I have built some tables:

Teams
Referees
Place

Building a form, how can I select both teams from the same table, as well as the 3 referees for that match?

Hope this makes sense...

Thank you

 

[KenReay]

Hi

Think you are going to need at least one more table (tblMatches)

tblMatches
MatchId (PK)
HomeTeamId
AwayTeamId
DateOfMatch

you also mention having three referees per Match, in which case you probably need another table:

tblMatchReferrees
MatchId ) Prime
RefereeId ) Key


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Evil6]

Thank you for your post, KenReay.

I see your point. Do you think I should use the same approach to the teams table?

I have the same problem as with the referees...

Also, the entry form for the data should it be constructed from a query of all these fields?

Once again, thanks.