In Table Design I've used a table lookup to define a field...TimeSlot. In datasheet view it correctly uses a drop down list with the correct text values, yet it stores a number in the file...the record's key. This appears to be correct. On a form I have a drop down list for TimeSlot, as well as a 2nd drop-down list that needs to use the text value of the TimeSlot to determine it's values. The name of the TimeSlot field, on the form, is TS. This part of the query for the 2nd drop-down list isn't working. WHERE Left(TS,1)=Left(Q_Classes.ClassCode,1) Is TS a numeric value, since a numeric value is stored in the file, OR is TS a text value, since that's what is visible on the form? How can I get the text value for TS?