Hi All
There are 2 Tables:
Tables are : Tbl1 ( 1col1,1col2,1co l3,1col4) and
Tbl2 ( 2col1,2col2,2co l3)
In Tbl1 (1col1,1col2,1col3 ) are composite primary key.So column values in column 1col2 may repeat
Now Columns 1col2 of Tbl1 and 2col3 of Tbl2 are of same data type
Now I need some solution to keep 1col2 as reference to the column
2col3 of table Tbl2 . what i need from 1col2 is distinct values of that column.
Is there any alternate if we cannot create relationship between Tbl1-> 1col2 and Tbl2->2col3 1col2 as reference column and 2col3 as foreign column
There are 2 Tables:
Tables are : Tbl1 ( 1col1,1col2,1co l3,1col4) and
Tbl2 ( 2col1,2col2,2co l3)
In Tbl1 (1col1,1col2,1col3 ) are composite primary key.So column values in column 1col2 may repeat
Now Columns 1col2 of Tbl1 and 2col3 of Tbl2 are of same data type
Now I need some solution to keep 1col2 as reference to the column
2col3 of table Tbl2 . what i need from 1col2 is distinct values of that column.
Is there any alternate if we cannot create relationship between Tbl1-> 1col2 and Tbl2->2col3 1col2 as reference column and 2col3 as foreign column