Skip to Content
0
Former Member
Jul 05, 2011 at 06:05 PM

problem assigning foreign key relationship

337 Views

Hi Experts,

I have created 2 ztables in se11, namely ztable 1 and ztable2 . I wanted to assign ztable1 as the check-table of ztable2, where the common key-field is zcolor.

To do this I have defined their value-table first, where ztable1 is the value-table for both.

Now in the foreign key relationship table of ztable1 I have chosen ztable1 as its own check-table and ztable2 as its foreign-key table, where the foreign-key field is - zcolor.

Whereas for ztable2, the check-table is ztable1 and the foreign-key table (and fields) are left blank.

Upon doing so none of the table can be activated and error messages are shown like - 'ztable1 can't be activated as it is the check-table and foreign-key table as well ' -


etc.

Please help me.