Search results

Thanks for this, I'll give it a go in the morning

Thanks for this, I'll have a look around. A fixture is the match between the home and away teams. The team table has a fixtureID which I thought would be a good foreign key for a relationship but I can't get it to work even with a junction table. Rob

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...

Not done any Access for 8yrs. Forgot a lot

Hi All, my names Rob. Married with a boy and girl, 2 granddaughters, 2 grandsons Retired 7yrs ago at 60. Revisiting ms Access after a 7yr lay off. Forgotten almost everything I self taught myself.