Value table

[Former Member]

Can anyone tell why value table used,difinition of value table

[varma_narayana]

Hi Mahesh..

Value Table is the DB table name Assigned in a Domain (in the Value Range Tab).

Advantage:

So whenever we create a Foreign key relation of a field with this Domain , the system will propose the Value Table as Check table. That means if the Domain does not have a Value table assigned then the Check table must be entered manually while creating Foreign key relation.

Remember :

Value Table does not restrict the Values of the field

Value table does not Generate the F4 help Values of the field.

Where as Creating a Foreign key relations ( Check table ) will provide these.

<b>reward if Helpful</b>