Difference between a check table and a value table

[Former Member]

Iyappa

[Former Member]

<copy&paste_and_everything_else_removed_by_moderator>

Edited by: Julius Bussche on Sep 3, 2008 8:52 AM

[Former Member]

Hi Iyappa ,

Check Table is Field level checking, but value table is domain level checking

Regards,

Vijay

[Former Member]

Check table: An input check for the field can be defined with a foreign key. This input check appears on all the screens in which the field is used.

,or first you must know the concept of foreign keys

foreign key is a field in the table that is connected to another table via a foreign key relationship. the purpose of the foreign key is to validate the data being entered in one table by checking against the valid set of values in another table.the table that contains the foreign key is called the foreign key table.the table that contains the valid set of values is called the check table.