linking tables in target database

yaminids · Post by **yaminids** » Wed Oct 27, 2004 10:18 am

Hello there,

Can anyone explain to me how to link two or more tables in the target database with a common column 'A'. Actually I am populating this(common) column in a table and tying to link this column with the other two tables.

Thanks in advace.
-Yamini

mhester · Post by **mhester** » Wed Oct 27, 2004 12:43 pm

I'm not sure if you are asking for DS help or database design help, but I think you are trying to make a connection between two tables that might have a many-to-many relationship by creating a "linking" table with only one column.

If this is the case then you should not create the "linking" table with one column, but rather you should create this table with two distinct FKs that are the keys to the two tables you are trying to relate. A field in a table should never contain multipart or multivalued data and trying to create a relationship between two tables with one column might not be a good idea.

I'm not sure I helped or was even close, but that's how I read the question.

Regards,

yaminids · Post by **yaminids** » Wed Oct 27, 2004 2:07 pm

Hello Michael,

Thank you very much for your help. I think I got the solution for my problem.

-Yamini

mhester · Post by **mhester** » Wed Oct 27, 2004 3:28 pm

If you have the chance could you share the solution with the forum?