I have a created an access database which currently has 2 tables.
One table (ItemsTable) contains the fields ItemCode, ItemDesc, Location, OpenBalance, plus some other not so relevant fields.
The other table (TransTable 'as in transaction') contains the fields, Item, QtyIn, QtyOut, and very importantly, Batch, plus some other not so relevant fields.
This operation has to operate on a FIFO (First In, First Out) system.

What I am now asking for asistance with is....

1. Am I on the right track with my approach to stock control with this structure.

2. Should I imcorporate a running balance per Item, per Batch somehow, or should I program calculations to get the current balance per Item, per Batch?

This is my first attempt at a stock control database so I am very much open to suggestions/samples.

I am working with vb.net and displaing data in a dgv via sql statements with oledb.

Sorry if I have not eplained this situation properly.
Thanks for any help.