topic Re: Adapted Foreign Key in Application Development and Automation Discussions

Adapted Foreign Key

Former Member — Mon, 31 Jan 2011 09:59:12 GMT

Hi all,

I have a doubt in creation of Adapted Foreign Key.

I have used 3 tables. The details are -

Table Type Table Name Field Entries

Check Table YCT Country, Region INDIA, MUMBAI

Foreign Key table YFKT Country (-> Foreign Key)

Another Table YADFKT Region MUMBAI

Since this is an adapted Foreign Key, So the relationships are -:

YCT-Country = YFKT-Country

AND

YCT-REGION = YADFKT-Region

But when I am trying to enter data "INDIA" in YFKT then it is saying "Entry is not present in Check Table".

Why this error is coming ?

Thanks,

Debi

Re: Adapted Foreign Key

Clemenss — Mon, 31 Jan 2011 12:18:54 GMT

Hi Debidutta Mohanty,

please show your message without any further explanation to someone not directly related to the task.

If she understands it, we are all too stupid.

You may set up a table-like description, format it as code to preserve the formatting so that we can see what fields with what data elements with what checktables are used.

Hint: Apply the check table for country to the underlying domain.

Regards,

Clemens

Re: Adapted Foreign Key

Former Member — Mon, 31 Jan 2011 13:41:53 GMT

Hey Li,

Cool Down Buddy .... Now pls. check -:

I have a doubt in creation of Adapted Foreign Key.

I have used 3 tables. The details are -

Table Type -> Check Table

Table Name -> YCT

Fields -> Country, Region

Values -> 1 entry -> INDIA, MUMBAI

Table Type -> Foreign Key table

Table Name -> YFKT

Fields -> Country

Table Type -> Another Table

Table Name -> YADFKT

Fields -> Region

Values -> 1 entry -> MUMBAI

Since this is an adapted Foreign Key, So the relationships are -:

YCT-Country = YFKT-Country

AND

YCT-REGION = YADFKT-Region

That means i want Valid "Country" should be present in check table (YCT) and for that a valid "Region" must be there in "YADFKT".

But when I am trying to enter data "INDIA" in YFKT then it is saying "Entry is not present in Check Table".

Why this error is coming ?

Thanks,

Debi

Re: Adapted Foreign Key

Former Member — Wed, 02 Feb 2011 09:36:23 GMT

Hi Li,

I am waiting for your answer friend.

Thanks,

Debi

Re: Adapted Foreign Key

Former Member — Thu, 03 Feb 2011 14:10:24 GMT

Any help from any body...?