hi value table

[Former Member]

hi gurus,

i have entered some values in domain .so when i am creating entries in the tables the values which are different from this values are also stored in the table.i .e these values check is not working.pls help me out.

thanks ,

rajesh

[Former Member]

the values at domain level are used to get the f4 help value while entering the values into the database table. if we maintain foreign key or check table then it will check for the existance in the value u enterd in the database of the check table or foreign key table.

so maintain foergin key relationship for checking of values

[Former Member]

What you need to do to restrict the values in the field is create a foreign key relationship with other table.

A foreign key creates a link between two tables T1 and T2. Every primary key field from T1 (check table) is assigned a field from table T2 (foreign key field). The fields from T2 assigned to primary key fields are marked as foreign key fields.

The most important function of the foreign key is the support of data integrity. The foreign key fields can only accept values which appear in the primary key of the check table. During input the values of the foreign key fields can thus be checked against the entries of the assigned key fields of the check table.

Foreign keys are also the foundation for defining lock objects, maintenance views and help views. These objects contain fields from several tables. All the tables used in such an object must be linked with foreign keys.

[Former Member]

Hi,

For that instead of vale table u have to specify a Check Table.

Value table won't restrict you from entering different data.

Regards,

Renjith Michael.

[Former Member]

Thanks