Adapted Foreign Key

[Former Member]

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

[Clemenss]

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

[Former Member]

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

[Former Member]

Hi Li,

I am waiting for your answer friend.

Thanks,

Debi

[Former Member]

Any help from any body...?