Structuring queries/reports so my employees can use the database

[parkerk]

I’m new to Access (using 2003) and am creating a vendor management database
for my company, an industrial distributor. I’ve got a basic database built,
but I’m having trouble with structuring the queries/reports, so that my
employees (not computer savvy) can use the data.

I’ve created a vendor database with three tables: tblProduct, tblVendor,
and tblProductVendor. The product table lists about 200 names, the vendor
table lists about 200 vendors (and related contact information), and the
ProductVendor table links the two other tables, plus has a field for the
preferred vendor.

I want my employees to be able to:
1. Use a drop-down menu of product names, pick one, and query the database
for all vendors that manufacture that product, with the preferred vendor
included.
2. Use a drop-down menu of vendor names, pick one, and query the database
for all contact information for that vendor.

How do I accomplish these tasks?

Thanks for any help you can give - KP

 

[Duane Hookom]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. I use
this in many of my applications and users seem to catch on to it very
quickly.

 

[parkerk]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. I use
this in many of my applications and users seem to catch on to it very
quickly.

--
Duane Hookom
MS Access MVP





Thanks Duane - I appreciate your response, and I'll give it a try. KP