Access 07 - Getting info from a table to use in a form
I creating a Consumables Database for Printer Toners to book in and out and amend stock.
The tables I have are:
I am trying to create a query where the Purchased Consumables form is taking the stock number from the Consumables table and places this into the field "lblCurrentStock".
I have written this in SQL:
FROM tblPurchasedConsumables INNER JOIN tblConsumables ON tblPurchasedConsumables.luCurrentStock=tblConsumab les.QuantityStock
But it does not return anything.