1 of 1 people found this helpful
The precise syntax will depend on the precise FIELD. However, for KEY1, as an example:
select * from lookup where fieldname like 'KEY1%V' order by Entry
The important realities to recognize:
- Validated lookups (AKA Drop-down values) are stored in the LOOKUP table.
- For fields in the CONTACT1 and CONTACT2 tables, the fieldname in the LOOKUP table BEGINS with the NAME of the field, and ENDS with V (v for "value").
- For other fields throughout GoldMine (NOT in the CONTACT1 or CONTACT2 tables), it depends on where that field is located as to how it's stored in the LOOKUP table. The fieldname value will always END in a V. I often do "searches" based on a unique VALUE I know is used for a field in order to "find" it within the LOOKUP table.
Hope this feedback helps. Please let me know if I need to clarify anything.