Product Search Form

[DanEaton]

I'm looking to make a form that allows a user to select a product from a combo box, hit a search button, and then display all of the catalogs that match that search criteria. I'm not sure what the best way to go about doing this is. what I'm looking for is something like the following:

Product Type: [Combobox]

[Search button]

catalog ID Filed Under Format Catalog Date
2 Dufferin Valves CD July 2002
878 Valves R' Us Catalog March 2000

In other words I want to find all of the relevant catalogs based on the product that is entered. My problem is I don't know how to set this up. I have 5 tables in my database. I don't know how to search the recordsets againstthe value in the combo box. This value would most likely be the product ID I'd imagine. I also can't think of how to output the results of the search into this tabular form. I want a list of all the matching results. Do I use a form/subform? Do I need code? What do I do? Thanks.
-Dan Dan Eaton
deaton@caemachinery.com

 

[LittleSmudge]

y Dan,

What are your five tables ?

List them out in this format

tblNameofTable
PrimeKeyField
otherField1
otherfield2
etc ..

tblNextTable
etc .. ..
etc ..

Then, how are they joined ? - What is the relationship between them ?

Then what are the fields ( from which tables ) that you are wanting to display ?

On the form with the combo box and button - what table is this form bound to ( if any ) ?


G LS