Relationship's Question

[amanco]

hello,

i am new to this and i appreciate your help.

if table_A is related to table_B (1-to-many)
& table_B is related to table_C (1-to-many)

Do i have also to relate table_A to table_C? or it is related by default?

thanks


P.S table_C has both table_A and table_B primary keys as foreign keys.

 

[amanco]

Pat Hartman i actually have a foreign key from table_A in table_C... are you saying there is no need for this key as long as table_B in between i.e is it better to remove it? thanks

 

[Dick Vernon]

As you guessed A and C are related by default. Dick.

hello,

i am new to this and i appreciate your help.

if table_A is related to table_B (1-to-many)
& table_B is related to table_C (1-to-many)

Do i have also to relate table_A to table_C? or it is related by default?

thanks


P.S table_C has both table_A and table_B primary keys as foreign keys.