Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
query a table and subform
0 views
Skip to first unread message
Icy
Jan 6, 2010, 1:34:01 PM1/6/10
to
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.
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.
0 new messages