If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 table design - relationships
I have what may seem like a silly question.
I want to create a 3 table database. tbl1 - who! - names, title, category tbl2 - where! - contact info tbl3 - events! - places, dates, times However, tbls 2 and 3 have nothing to do with each other. Can I create relationships of 1-many between tbl1 and tbl2 and 1-many between tbl1 and tbl3? Is this possible without creating a relationship between tbl2 and tbl3? Just to be difficult, if it at some point I wanted to create a relationship between tbl2 and tbl3, would that be possible? If possible, would it be easy to do? How would I create a many-many relationship? Thanks |
#2
|
|||
|
|||
3 table design - relationships
It is OK to have 1:Many for tbl1:tbl2 and tbl1:tbl3. Just by doing that you
have an indirect relationship between tbl2 and tbl3 that could be revealed with queries. If you could give a little more info on the entities and the applications it would help. For example, could there be multiple WHOs responsible for an EVENT?, do you want to create contact information related to events? "Christine" wrote: I have what may seem like a silly question. I want to create a 3 table database. tbl1 - who! - names, title, category tbl2 - where! - contact info tbl3 - events! - places, dates, times However, tbls 2 and 3 have nothing to do with each other. Can I create relationships of 1-many between tbl1 and tbl2 and 1-many between tbl1 and tbl3? Is this possible without creating a relationship between tbl2 and tbl3? Just to be difficult, if it at some point I wanted to create a relationship between tbl2 and tbl3, would that be possible? If possible, would it be easy to do? How would I create a many-many relationship? Thanks |
#3
|
|||
|
|||
3 table design - relationships
"Christine" wrote in message ... I have what may seem like a silly question. I want to create a 3 table database. tbl1 - who! - names, title, category tbl2 - where! - contact info tbl3 - events! - places, dates, times Pretty straightforward. However, tbls 2 and 3 have nothing to do with each other. Can I create relationships of 1-many between tbl1 and tbl2 and 1-many between tbl1 and tbl3? Certainly. Is this possible without creating a relationship between tbl2 and tbl3? Certainly. In fact - in the real world - there IS no relationship, so it would be silly to try to create one! Just to be difficult, if it at some point I wanted to create a relationship between tbl2 and tbl3, would that be possible? If possible, would it be easy to do? How would I create a many-many relationship? You already did: via tbl1. Note that a Query joining all three tables will show lots of duplicate values, and you ordinarily would not create such a query. Instead you could use a Form (or Report) based on tbl1, with separate subforms (subreports) for tbl2 and tbl3. -- John W. Vinson/MVP |
Thread Tools | |
Display Modes | |
|
|