I am testing an ODBC connection. My SQL knowledge is pretty limited, but I was wondering how do you get a text value out of a custom list. I am pulling out a transaction line and it returns a status ID instead of a text value. The ID is the internalid on the list, but I am not sure how exactly I would connect to the list to do a lookup.