difference between check table and value table

[Former Member]

what is the difference between

check table and value table?

[Former Member]

Reward points..

[Former Member]

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

[Former Member]

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 .