Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined
Check table :
Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.. While creating a table if you want to be sure that a field can have some values and these are in a certain table, you can give IT this table as CHECK TABLE.
Important Difference
The contents of the check will be used as an input help(F4 Help) for a particular field on which a check table is assigned. But the contents of Value Table are never used in Input Help.
f all the fields or components that refer to the domain should be checked against a certain table this table can be defined as the value table of the domain.
When a foreign key links two tables by assigning fields of table T1 to the primary key fields of Table T2,table T1 is called the foreign key table(dependent table) and table T2 the check table (referenced table)
Value table is a domain level checking .In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined
Check table :
Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.. While creating a table if you want to be sure that a field can have some values and these are in a certain table, you can give IT this table as CHECK TABLE.
Important Difference
The contents of the check will be used as an input help(F4 Help) for a particular field on which a check table is assigned. But the contents of Value Table are never used in Input Help.
Bluesky
