DESIGN DATABASE RELATIONSHIPS

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
 
J

John W. Vinson

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top