LOOKUP

DBase Directory Location: GMBASE / COMMON
Table Description: Lookup file – contains a record for each defined look-up entry

Table Indexes
Name DBase Index SQL Index ID
LOOKUP FIELDNAME+ENTRY FIELDNAME+ENTRY -
LKURECID RECID RECID -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
FIELDNAME String 11 Field Name (followed by ‘H’ if lookup name, ‘V’ if lookup entry)
LOOKUPSUPP String 10 For ‘H’ records, a string of Y/N flags indicating settings.
Position Description
1 Insert closest match
2 Force valid input
3 Allow blank input
4 Allow adding
5 Allow editing
6 Allow deleting
7 Pop-up when selected
8 Capitalize first letter
9 Auto fill
ENTRY String 40 Description
U_ENTRY String 40 Upper-case shadow of Description (SQL Only)
RECID String 15 Record ID