ODBC > Find the Correct Field Id on ODBC for List Type CustomFields

1. Create a custom List on  Setup>Customisation>List>New
2. Create a custom field with type as List. Example custom Entity field

• Customisation > Lists, Records, & Fields > Entity Fields > New
• Type value on the Label Text box. (e.g. TEST VALUE)
• select List on the Type select list
• on Applies to Tab check customer checkbox
  

3. Open an ODBC application and invoke SQL select to find the field.
   Example: Select * from Customers

---

Solution:
   - Notice that the new custom field is labelled as TEST_VALUE_ID
   - When a custom field is a list type, the label on ODBC view is appended with _ID.