3 table design - relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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
Click to expand...

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?
Click to expand...

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?
Click to expand...

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.
 
Back
Top