topic Re: Cannot validate foreign key in Application Development and Automation Discussions

Cannot validate foreign key

Former Member — Fri, 04 Feb 2011 01:08:17 GMT

Hi,

I am facing problem validating input on a foreign key field.

I have created a foreign key table ZTEST with 2 fields MANDT and LAND1 and have declared a foreign key on LAND1 using T005 as check table.

But the data that i enter in this table is not getting validated even if enter an invalid country code.

I am working on IDES 4.7

anilsonesar — Fri, 04 Feb 2011 06:29:42 GMT

Hi Amit ,

As you are Saying you have kept foreign Key.

See "Check Required" Check Box is Marked.

Regards,

Anil Sonesar

Former Member — Fri, 04 Feb 2011 10:28:11 GMT

I think you don't create the relationship between the primary table and the foreign table.

Check it out