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
linking tables in target database
Moderators: chulett, rschirm, roy
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,
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,
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
linking tables in target database
Hello Michael,
Thank you very much for your help. I think I got the solution for my problem.
-Yamini
Thank you very much for your help. I think I got the solution for my problem.
-Yamini
If you have the chance could you share the solution with the forum?
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com