Hi to all
I have the following tables
TrainerTbl
TrainerID
HorseID
HorsesTbl
HorseID
RaceID
RaceTbl
RaceID
RaceDate
RaceDetailsTbl
RaceID
Winner (drop down box from HorsesTbl)
Second (as above)
Third (as above)
I have created relationships between TrainersTbl (HorseID) and HorsesTbl (HorseID) and also
HorsesTbl (RaceID) and RaceTbl(RaceID)
and RaceTbl (RaceID) and RaceDetailsTbl (RaceID)
So when i click on a Trainer it shows the Horses trained.. Good
When I click on one of the Horses that are trained it shows the race numbers the horse has raced in... Good
Now when i click on the race number I get nothing I would like the database to show the relevant races
Please excuse me if i haven't explained it clearly enough
Hope someone can steer me in the right direction
Many Thanks