many-to-many relationship?

[hockey8837]

Hello,
I'm working on a DB that I think needs to be setup in some way as a many-to-many relationship. Now, from what I understand, Access doesn't necessarily create 'many-to-many' but, you instead create multiple one-to-many relationships.

What I'm stuck on is this; I have in my DB a table, tblLocation, which tracks the site #s and address of street trees. Then, I have tblRequest, which is the person who makes the request to have a tree planted or tree work done, so all this contains is name, phone, and email. Finally, I have tblOwner, who is the property owner of the Location, and may or may not be the person who made the request, and this contains their contact info.

My question is, how do I setup a relationship between the 3? Do I need to include a tblLocation foreign key in both the other 2 tables? Or, do I need to setup 2 different associate tables, i.e. Location & Request, and Location & Owner, or even a 3rd Request & Owner?

Thanks in advance!

 

[jdraw]

Hello,
I'm working on a DB that I think needs to be setup in some way as a many-to-many relationship. Now, from what I understand, Access doesn't necessarily create 'many-to-many' but, you instead create multiple one-to-many relationships.

What I'm stuck on is this; I have in my DB a table, tblLocation, which tracks the site #s and address of street trees. Then, I have tblRequest, which is the person who makes the request to have a tree planted or tree work done, so all this contains is name, phone, and email. Finally, I have tblOwner, who is the property owner of the Location, and may or may not be the person who made the request, and this contains their contact info.

My question is, how do I setup a relationship between the 3? Do I need to include a tblLocation foreign key in both the other 2 tables? Or, do I need to setup 2 different associate tables, i.e. Location & Request, and Location & Owner, or even a 3rd Request & Owner?

Thanks in advance!

There are various data models here:
http://www.databaseanswers.org/data_models/index.htm

Here's one that deals with Customers, Orders, Deliveries that may be a start for you.
http://www.databaseanswers.org/data_models/customer_deliveries/index.htm

http://www.databaseanswers.org/data_models/customer_deliveries/facts.htm

 

[vbaInet]

:O All those models!!!

 

[hockey8837]

Thanks! Looks like I'll be busy for a while.