Question problem with creating a really simple inventory database

shinmaster19

New member
Local time
Tomorrow, 02:04
Joined
Apr 17, 2015
Messages
3
Greetings,

I am a new member to the access and programming world so do expect nothing much from me :p.

I am trying to make, for now, a really simple inventory database for an immediate practical use.

I expect my inventory to be of similar items from different suppliers and from different batches everytime it is received. All I want to do is to input an item with its unique batch number and sell the exact same item, noting its particular batch no.

I have 2 tables, Stock and Sales, with its respective forms and a report of the current stock level. Stock-Sales : 1 to many relationship, outer joins All stocks.
Stock form: only inputting data
Sales form: autopopulate form by choosing the batch no.
Report: shows the Qty on hand

My problem is that, on the sales form, I displayed qty on the batch no. combo box.
Batch no. (combobox_salesform): shows - BatchNo;Colour;Type;Qty.
However, these qty would remain the same as when it was inputted despite sales were made on that particular items. :banghead:

I understand that I would look at my Report when deciding the sales, thus I will not make a mistake selling more than possible, however, intuitively when I input data into Sales form, it would look wrong because the Qty was not updated and of course, it increases the error rate.:(

So, could anyone give me any tips regarding this?
I only want to track my inventory levels.

Thank you.
 
I did read that before I posted this, but i still don't quite get it.
I required to have a stock level for each unique batch no. and DSUM() would not group the sum for each batch no. (CMIIW) and even if it does, it still does not help me with the issue of not updated "Qty" in a combobox display list
 

Users who are viewing this thread

Back
Top Bottom