I have 3 table
- stock IN
ID (primary key)
store location(V C)
now current stock will be calculated by
** Stock IN[QUANTITY],**
** [PRODUCT] = [_THISROW].[Product Name])) -**
** Stock out[QUANTITY],**
** [PRODUCT_NAME]= [_THISROW].[Product Name]))**
This is only display the number of stock
But i have to display current stock of an item by store location and current stock of a item in that location .
how this possible??