Relationship advice

[KenCunningham]

Morning folks (well it is here anyway). Not about to ask anything of a personal relationship nature here! However, I would appreciate a little advice on how to get a one-to-many relationship working, having only used basic flat files (one-to-one) in the past.

I currently have two tables, Users and Purpose. Purposes are the aims of the user in taking a particular course of action. A user can have several purposes, so presumably I need to link the tables so that the userid (key field) appears in the purposes table to indicate that the user has this purpose in mind? My basic question is, do I then need a table to show the relationship, ie the userid and the purposes they are linked to and how do I set this up?

The internet - allowing those who don't know what they're talking about to have their say.

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

You might want to google "Junction table". If you still have any questions on how to implement this in Access, come back and ask.

Duane
Hook'D on Access
MS Access MVP

 

[KenCunningham]

Thanks both - I'll do some digging and get back to you if necessary.

The internet - allowing those who don't know what they're talking about to have their say.