Hi, Ive been away from access for 8yrs. Coming back trying to design darts league. I have tables
Division: divID, divName
Team: teamID, teamName, divID, fixtureID
Players: playerID, firstBame, lastName, teamID, active(y/n)
Fixtures: fixtureID, fixtureDate, homeTeamID, awayTeamID
1 to many joins: Division-Team-Players
Which work fine.
I've put in some fixture numbers and can display them ok but can tie to any results in a 1 to many table even with a junction table.
I've scoured the web, been back to basics with tutorials from Richard Rost but a lost.
Any pointers? Nothing of use anywhere about sport, soccer, football etc. All concentrate on order db's.
Thanks in advance
Division: divID, divName
Team: teamID, teamName, divID, fixtureID
Players: playerID, firstBame, lastName, teamID, active(y/n)
Fixtures: fixtureID, fixtureDate, homeTeamID, awayTeamID
1 to many joins: Division-Team-Players
Which work fine.
I've put in some fixture numbers and can display them ok but can tie to any results in a 1 to many table even with a junction table.
I've scoured the web, been back to basics with tutorials from Richard Rost but a lost.
Any pointers? Nothing of use anywhere about sport, soccer, football etc. All concentrate on order db's.
Thanks in advance