query a table and subform

I

Icy

Help,
I have 3 tables
1. Printer table: printerID, ModelID, SerialNum, MACAdd
2. Toner table: TonerID, ModelID, PartName
3. Invoice table: InvoiceID, Date, Qty, PrinterID, TonerID
How can I pull up toners based on the printerID in Invoice table? I set the
TonerID as a combo box, Could anyone help me with the query that i need. The
inovoice table actual is a subform under printer in the Form. so when I
choose the printer from the main form the subform printerID changes
accordingly, I just don't know how to generate a list of toner for user to
choose based on the printer or model.
Any help will be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to design relationship between tables 1
Query expression using multiple records in same table 5
Creating a Search using a combo box and then creating a report. 4
DLookup in Continuous form 0
Limiting user choice to subform contents 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
MS Access Stock Control 0
Subform linked to another subform 0

Top