Stuck with search :(

[Xenix]

I have a table with interest groups.
They have labels Prod1 to prod68 they are
tick boxes. now I want to do a search form on say prod1 and view how many customers are interested in prod1 I would like a combo box where I can select this but how can I give them meaning full names in the combo?

Thank you in advance
Mike

Also I have just noticed that in design view there is the description field that shows on the bottom of the screen when that field is selected. Is there a way to reference that?


[This message has been edited by Xenix (edited 02-07-2002).]

 

[Fizzio]

In your table, add a txt field to the design eg ProductDescription. Use this in the query/Rowsource statement of the combo so combo looks a little like this

Column
0 | 1
ProductID | ProdDescription

set the column widths to 0;

Use the value selected by the combo as a criteria for ProdID in your query. (Even better use a multi select list box to identify 1 or more products - but I haven't used this yet myself!)

ps Rather than having 68 fields, create a junction table called CustomerInterest, have FK for CustomerID and ProductID then query this table.
Hope this is clear and is helpful