MS Access Stock Control

P

Phreake

Hi Guys,

I am doing a stock list of Printer tonors, with the following tables
Printer_tonor_Stock Tonors Printers
----------------------------- ------------- --------------
RecordID TonorID PrinterID
PrinterID Tonor Printer Name
TonorID Colour Serial Number
Date Stock Model
DepartmentID


I have done a form with th Printer_Tonor_Stock Table, basically what I
want is, when I fill out a record (combo box of TonorID), i want a
query (or 2) to say if the Printer_tonor_Stock.tonorID =
Tonors.TonorID, then Tonors.Stock should = Tonors.Stock-1.


How can I put this into a query pleeease Help!! (the results will be
shown at the bottom of the Printer_Tonor_Stock form). Also please
excuse my bad database design as I am just a lowly Helpdesk guy :eek:(


Thanks in advance


Phreake
 

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

query a table and subform 0
Limiting user choice to subform contents 1
stock control stuff 3
Adding data to MS Access from csv file 0
Access 2007 0
Stock Control System 3
Access 2007 Reports 4
Retrieving stock information in Access 1

Top