Relating records between form and sub-form

  • Thread starter news.microsoft.com
  • Start date
N

news.microsoft.com

Using Access 2000
I have a simple 2-table database - Customers and Tooling.
Customers contains customer name address, etc.
Tooling contains the description of tooling used to produce parts for each
customer. Tables are linked by CustomerID which is the index record from the
Customer table.

I have a form/sub-form. The form includes the Customer Name and a combo-box
for a customer name look-up.

The sub-form includes all the tooling info.

I can select the appropriate customer with the combo box and that will limit
the available list of tools in the sub-form.

My problem: How can I do a lookup on a part number located in the sub-form
(or in a separate query) to identify the customer it belongs to? I've not
used VBA before, but I am imagining that is where the solution is???

Mack
 
Top