I don't know what a Fixture is so I'm assuming it's a contest between two
teams. If correct, your Fixtures table would be like a schedule looking
like:
TblFixture
FixtureID
FixtureDate
etc
You then need another table associating the two teams with a Fixture. That
table would liik like:
TblContest
ContestID
HomeTeamID
VisitingTeamID
HomeTeamID and VisitingTeamID would be foreign keys related to TeamID in
your Team table.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
<pa************@blueyonder.co.uk> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Could someone please help shed a little light on a database query I
have.
Here goes:
I am in the process of building a access database for a local football
team and have the following tables.
Players
Fixtures
Teams
Clubs
Player Positions
Player Status (ie.retired, injured etc)
Sponsors
Sponsor Agreements
etc....
My problem is, that in creating a fixture I am having problems
identifying how to populate the fixture table as the relationship is
currently 'A team can have many fixtures and a fixture must have two
teams'.
In relational terms I can't see how to pull two teams from the team
database to make a fixture???
Apologies if the answer is staring me in the face but I have run out of
coffee and have resorted to finding a soft spot on the wall to bang my
head against....
Any help would be most appreciated.
Regards,
Paul