I have a table with a field that is a lookup to a table listing possible categories in which I can place a student. I'd like to perform a query that includes all records for which a certain category ("Silver Creek") is selected. The field type is number and has this under the lookup:
SELECT [T_Category].[ID], [T_Category].[Category] FROM T_Category ORDER BY [Category];
The bound column is 1 (the index/unique ID) and the column count is 2.
Any help is greatly appreciated.