BrianSw

I Guess Lookup tables are a Bad idea now that I understand what is actually going on. I'll have to try something else instead. Brian

I'm using Labview 7.1 with ADO Toolkit from ib-berger.com. I am using MS Access for the database. I have a table which uses several lookup tables to fill some of the fields in the Main table. When reading the table with the ADO toolkit the fields that are filled by the lookup tables return the indexes to the data rather then the actual data stored in the lookup tables. Other fields in the main table that don't use lookup tables display the correct data. Question is how do I get the actual values of these lookup tables rather then the indexes to the fields of the lookup tables? I am using the ADOtool_Select Data.vi with a SQL statement to get the results to fill a Labview table. Thanks for any help it is greatly appreciated. Brian