NIPO Fieldwork System Version 1.14
LookupFieldsMulti
Links multiple-coded fields with the LookupValues table. For internal use by the NIPO FMS.
LookupFieldsMulti table
|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
SourceTableName
|
Source table name
|
varchar
|
50
|
NOT NULL
|
|
MultiTable
|
Multi-table
|
varchar
|
50
|
NOT NULL
|
|
MultiIndexLabel
|
Multi index labell
|
varchar
|
50
|
|
|
LookupIndexValue
|
Lookup index value
|
int
|
|
|
|
LookupTableName
|
Lookup table name
|
varchar
|
50
|
|
|
MultiIndexValue
|
Multi index value
|
int
|
|
NOT NULL
|
|
MultiLookupField
|
Multi lookup field
|
varchar
|
50
|
|
|
MultiSourceField
|
Multi source field
|
varchar
|
50
|
|
|
MultiSourceField2
|
Multi source field 2
|
varchar
|
50
|
|
|
|
|
|
|
|
|
