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.
There are currently 1 users browsing this thread. (0 members and 1 guests)