inventory sorting

[alex_raju]

Dear sir,



Actually I am trying to do a stock inventory access database, I would like make it in below method..
barcode model Computer balance Physical balance Variance qty Variance amount
22222 Abc 50 25 -25 -####
55555 Def 20 20 0 0
44444 Ghi 40 0 -40 ####
33333 jkl 30 30 0 0

When inventory time we cannot count same goods all at a time, I mean for example according to above table 22222 barcode items may be we can find many place like shelf 1, shelf 2 or display. So, if I entry barcode like below form, it should show in main form like above form. Please help how to sort or any method for it done.

barcode model Physical balance
22222 Abc 5
22222 Abc 18
22222 abc 2
33333 jkl 8
33333 Jkl 22
55555 Def 20



Thankyou
Alex_raju

[orange]

There are some sample data models for Inventory Control here.
http://www.databaseanswers.org/data_...tail/index.htm
http://www.databaseanswers.org/data_...ters/index.htm

They may provide some insight into the tables and structures involved.
There is a database template from M$oft here
http://office.microsoft.com/en-ca/te...001047741.aspx

I would recommend some research on Normalization before you go much further.
See the first few topics here
http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck.