DESIGN DATABASE AND RELATIONSHIPS

[smita]

I need additional help with the last question i posted.
There are different types of interschool competions to be held. For this
students from different schools can participate. So one student can
participate in many competions. There will be some no of judges who will give
marks to each participant.
Also one judge can be a judge for more than one competion. how do i design
and set relationships. please help.

 

[John W. Vinson]

I need additional help with the last question i posted.
There are different types of interschool competions to be held. For this
students from different schools can participate. So one student can
participate in many competions. There will be some no of judges who will give
marks to each participant.
Also one judge can be a judge for more than one competion. how do i design
and set relationships. please help.

See my answer to your previous post. The same logic - a third table to model
the many to many relationship - would apply to students.

Also see the tutorials at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Crystal's chapter on relationships may be apropos.