What kind of relationship that I can create here?

[taoday]

Ok, here is the situation: I have 2 tables : "Events" and "Participants". The Participants are the persons who attend the "Events". What I want to do is when I creat a new record in the "Events" table, the name of the participants would be update in the "Participants" table. I'm not sure what kind of relationship in this case I should create?

 

[fneily]

Study Normalization and Relationships before you proceed to build an Access database.
You have a many-to-many relationship: an Event can have many participants and one participant can go to many events. NO relational database management system, like Access, likes this situation. So, to resolve this, you will create a "junction table" to create two one-to-many's.
You will have three tables: tblEvents, tblPart., tblAttend.
The tblAttend will look like this:
AttendID Primary key
EventID Primary key of tblEvent
PartID Primary key of tblPart.
DateAttended Any COMMON fields to both Event and Particip.

Then in query, you will connect tblEvent to tblAttend through EventID AND tblPart. to tblAttend through PartID. This creates two one-to-many's and retreiving info is now quite easy.

Warning: if you don't study or take courses in Access, you'll have major problems down the road.

 

[PHV]

Have a look here:

http://r937.com/relational.html

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886