syntax error in table

[Former Member]

Hi

I have created table Z1YCHSTATUS_D.

when i activate this table i got syntax error.

Errorr is

Check table Z1YCHSTATUS_D is also foreign key table

Anyone pls advise me

[Former Member]

Hi Kumar,

Check table always contain one record corresponding to the key.

Where are the Foreign key is related to the check table .

&**************Reward Point if helpful***************&

[Former Member]

You might have given the foreign key relationship with the same table Z1YCHSTATUS_D itself.

The table itself was specified as check table. Only those values which already exist in the table are therefore possible. For this reason no values could be entered in the table.

Delete the foreign key to the field or remove the flag for the key field.

Regards

Kannaaiah