DESIGN DATABASE RELATIONSHIPS

  • Thread starter Thread starter smita
  • Start date Start date
S

smita

I have to design a datbase where i have created two tables Competition which
contains information about competitions. Another table Judges about judge
info. But one person(judge) can be a judge for more than one competitons. how
do i set the RELATIONSHIPS.
please help
 
I have to design a datbase where i have created two tables Competition which
contains information about competitions. Another table Judges about judge
info. But one person(judge) can be a judge for more than one competitons. how
do i set the RELATIONSHIPS.
please help
Click to expand...

If one Judge can judge many Competitions, and each Competition can have many
Judges, then you need *a third table*:

Competitions
CompetitionID <primary key>
CompetitionDate date/time
Venue
<other info about the competition>

Judges
JudgeID <primary key>
LastName
FirstName
<other biographical data>

Judgeships
CompetitionID <link to Competitions, what's being judged>
JudgeID <link to Judges, who's judging it>
<other info about THIS judge at THIS competition, if any is needed>

You could use a Form based on competitions, with a Subform based on
Judgeships; on the subform you could have a combo box to select the judges.
 
Back
Top