3 table design - relationships

C

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
 
B

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?
 
J

John W. Vinson/MVP

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top