Creating a product search capability into my database

[DanEaton]

I am new to Access and VBA programming and am trying to learn as fast as possible. I work for an engineering company and they want an Engineering Catalog Database to store their numerous catalogs. I used 4 tables: tblProductList, tblCatalogList, tblSupplierList, tblManufacturerList that are linked with relationships. I want to create a product-search capability in which a user is prompted with a combo box with all of the products and their associated product ID's and selects a product ID. (since the link between the tables is prodID and not ProdType). The search code would run this number (autonumber) against all of the prodID's in the tblCatalogList prodID field. The records would be displayed on a seperate form called frmCatalogSearchResults that contained fields for CatalogFormat, Manufacturer Info, SupplierInfo, and FiledUnder. So the user can then go look for the catalogs that contain this product. Any help would be awesome.

 

[zevw]

Since you are new

Look at the 3 Databases from Microsoft they have many solutions etc.

in the Directory C:\Program Files\Microsoft Office\Office\Samples

Northwind.mdb
Orders.mdb
Solutions.mdb

They have all the things you are looking it is virtually a whole company.

 

[LLudden]

Thats probably a lot of information to be putting in a combo box. A better way would be to have a form that lists all the products and clicking on one opens up the detail form for it.

It would help to see some table definations.