topic Re: difference between check table and value table in Application Development and Automation Discussions

difference between check table and value table

Former Member — Mon, 19 May 2008 09:32:34 GMT

what is the difference between

check table and value table?

Re: difference between check table and value table

Former Member — Mon, 19 May 2008 09:38:33 GMT

Reward points..

Re: difference between check table and value table

Former Member — Tue, 20 May 2008 07:19:05 GMT

Hi ,

I am giving my idea,

check table:

In Foreign key relationship ,we have two tables.

1) check table

2) foreign key table

Foreign key table is based on check table.

check table contains the valid set of values.

when we give any entry in foreign key table it checks the "check table" ,for the same entry.If same entry is there is "check Table" new entry is saved in foreign key table .

Value table:In domain we have one option called "value table",in that we can give any table name ( which is the check table for that domain)

Thanks,

Agalya

Re: difference between check table and value table

Former Member — Tue, 20 May 2008 09:21:30 GMT

Value table and check table are one and the same .

ONly difference is whenever ur creating a datalelement and when u attach the domain for that u will specify the value table for the values for that field .

When a new entry is made for the table field .. the check is done against the table specified in the Domain so as to check if the value is correct .

Thanks .