Option Group

[Rose]

When using an option group in a form by assigning each catagory a number.
How can we pull up the catagory name instead of the number in a query.

 

[Klatuu]

Create a Category table. Two fields CatID and CatDescr
CatID would be the field that would match the category number and CatDescr
would be a text field with the name. Include the table in your query joined
on CatID

 

[Rose]

Thank You
--
Rose

Create a Category table. Two fields CatID and CatDescr
CatID would be the field that would match the category number and CatDescr
would be a text field with the name. Include the table in your query joined
on CatID