Table Structure

[Joshann]

I've got some tables, and I want to make sure I relate them in the best possible way.

Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3

Would it be best to set them up this way or is there another way that would be better?

Fields for Table1
Table1_ID
.
.

Fields for Table2
Table2_ID
Table1_ID
.
.

Fields for Table3
Table3_ID
Table1_ID
.
.

 

[Robert88]

Hi Joshann,

With your tables being so general it is hard to determine if it is correct or not.

I suppose the relationship it has will depend on the context it has with the content of what is in the databases.

The information that is to be input into the tables has a relationship and it will determine the relationship your tables have with one another.

Robert88

 

[wazz]

what you have plus:

Fields for Table4
Table2_ID
Table3_ID

the PK is Table2_ID and Table3_ID combined.

 

[Joshann]

Robert88 - Thanks, but I do know for sure that
Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3

That's not the part I needed help with.

Wazz - Thanks! Table4 will give me the many to many relationship between Table2 and Table3. I appreciate it.