09-04-2008 5:11 AM
Hi
I have one table. In that two fields are primary key. I want to change the second PK as FK only. But when i am changing this field as FK. Its showing one error 'Primary Key Change not permitted for value Table ZCAUSECATMASTER' . How to avoid this error.
Please help me.
09-04-2008 5:38 AM
Hi.....
Remove that primary key for the second field and assign your foregin key..table to that filed.....
So when you give entries in that second filed it will be validated with its foregin key table......its nothing but check table...
what all values in the foregin table only can given.....
regards
raja
09-04-2008 5:34 AM
Hi,
Goto se14 and Adjust & activate the table there....
Regards
Karthik D
09-04-2008 5:38 AM
Hi.....
Remove that primary key for the second field and assign your foregin key..table to that filed.....
So when you give entries in that second filed it will be validated with its foregin key table......its nothing but check table...
what all values in the foregin table only can given.....
regards
raja
09-04-2008 5:42 AM
Hi,
remove that PK field from the table,activate this table and again declare that field.
In that way it will work.
Regards,
Amit