Newbie Question - linking tables with a query

  • Thread starter Thread starter Suz
  • Start date Start date
S

Suz

I have a list of companies and I wanted to be able to
press a button on the form that takes the user to the
list of products for only that company. Right now I have
a button that takes the user to another form that just
has a long list of products. They have to scroll through
it to find the products associated with the specific
company. Any assistance is greatly appreciated.
 
I have the perfect example for your question. Go to the
Northwind Sample Database that is part of MS Access and
take a look at the "Suppliers" form. At the bottom of the
form is a button (Review Products) that displays all the
products for the the supplier displayed in the current
form. You can use this as a template for your form.

Denny G.
 
I have a list of companies and I wanted to be able to
press a button on the form that takes the user to the
list of products for only that company. Right now I have
a button that takes the user to another form that just
has a long list of products. They have to scroll through
it to find the products associated with the specific
company. Any assistance is greatly appreciated.
Click to expand...

The simplest way to do this is to make the second Form a Subform of
the first one, linked by CompanyID.
 
Back
Top