What are the differences between Check table and Value table?

Check table VS Value table
1. It is maintained at the TABLE level.
1. It is maintained at the DOMAIN level.
--------------------------------------------------
2. It can be used to extract the data in the programs.
2. It can't be used to extract data since it is linked with the domain.
---------------------------------------------------
3. The Search Help is displayed from the Check table on the foreign key field of a foreign key table.
3. The Search Help is displayed on each field which is linked with the same domain of the Value table.
----------------------------------------------------
4. It forces the user to select any one of the check table field entries
4. It does not force the user since it has empty value by default.
No comments:
Post a Comment