I have a database which works as an information system for the upcomming olympics.
In tblAthletes is...
What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field.
Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.
In tblAthletes is...
- AthleteID (Primary Key)
- FirstName
- Surname
- And Various other fields not needed in this problem
- Gold
- Silver
- Bronze
- Also other field in this table
What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field.
Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.