Query Combobox values SQl

[nmulvihill]

I have a custom field that I am using as a combo box with a list of values. I would like to query those values via SQL and cannot seem to find where they are stored in the DB. I know that the field information for each asset is located tblAssetCustom.Custom5, but I need to know all of the options for Custom5.

[daniel_nierga]

nmulvihill wrote:
I have a custom field that I am using as a combo box with a list of values. I would like to query those values via SQL and cannot seem to find where they are stored in the DB. I know that the field information for each asset is located tblAssetCustom.Custom5, but I need to know all of the options for Custom5.

Hi nmulvihill, finally you got it?
I'm triyng to create a combo box with list of values from SQL query from my ERP Data base, in that case I want all customers list in this combo box. I dont' know how to start.

Could you help me?

Many thanks,

Daniel,

[MikeMc]

The tsysCustomNames table appears to contain all of the available options for custom fields.