emi_sastra
asked on
FOREIGN KEY TO FOREIGN KEY
Hi All,
I have 3 tables :
1. TMUNIT
1. UnitCode
2. UnitName
2. TMITEM
1. ItemCode
2. ItemName
3. UnitCode
4. UnitCode1
5. UnitCode2
3. TMPRICE
1. ItemCode
2. UnitCode
3. UnitCode1
4. UnitCode2
Is it possible to alter foreign key TMPRICE To TMITEM for UnitCode, UnitCode1, and UnitCode2. Foreign Key to Foreign Key.
Thank you.
I have 3 tables :
1. TMUNIT
1. UnitCode
2. UnitName
2. TMITEM
1. ItemCode
2. ItemName
3. UnitCode
4. UnitCode1
5. UnitCode2
3. TMPRICE
1. ItemCode
2. UnitCode
3. UnitCode1
4. UnitCode2
Is it possible to alter foreign key TMPRICE To TMITEM for UnitCode, UnitCode1, and UnitCode2. Foreign Key to Foreign Key.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi All,
Thank you very much for your help.
Thank you very much for your help.
ASKER
Why I am thinking of foreign key to foreign key.
Because I want to prevent TMITEM UnitCode being changed after TMPRICE has data.
How could I overcome this ?
Thank you.