Process to configure references

Configure the Lookup tabs in the Lookup Set form.

Columns not shown use default values. This example references vendors.

Use the Validation form to configure the FsValidationField table. Create a record here for each type of referenced object such as vendor or specification. This enables a validation mechanism, such as a list or lookup to be attached to the referenced object. The validation has most likely already been performed in the seed database. Look at the V\REFERENCE records to determine if any additional references must be configured.

Column Description Example
Validation_Code Use the V\Reference naming convention as shown in the example. V\REFERENCE
Validation_RecFmt Use the V\Reference naming convention as shown in the example. A
Validation_SubCode The object that is being referenced. Must match the value in the View Symbol column in the Lookup Set > Lookups tab. FORMULA

ITEM

VENDOR

Field_Name Use the example shown. OBJECTCODE
Field_No Use the example shown. 200
Set_Ind Use the example shown. 2
Enum_Ind Use the example shown. 1
Enum_Style Use the example shown. 1
Key_Check Same as Validation_SubCode. FORMULA

ITEM

Lookup_Code Same as Validation_SubCode.