3 table design - relationships

[Christine]

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

 

[Bruce Meneghin]

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?

 

[John W. Vinson/MVP]

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.