Shiva Kemkar
Registered User.
- Local time
- Today, 17:19
- Joined
- May 16, 2018
- Messages
- 31
Hello,
I am responsible for managing the sample stock and finding it difficult to find what sample went out and when and which sample came in to store.
want to create a access data base to record the information.
I have created a table with the fields below for material entry.
Lab_Sample_ID
Supplier
Sample_Name
Sample_QTY
every time the samples are out, i should be able to record the information using form and reduce the sample_QTY and the total stock to reduce.
similar way to update the stock if the material is in to store,
I have 2 more tables created to record the out and in of the material
Lab_Sample_ID
Sample_Qty_out; Date
Lab_Sample_ID
Sample_Qty_In; Date
Kindly share some code which can do this. Thanks
I am responsible for managing the sample stock and finding it difficult to find what sample went out and when and which sample came in to store.
want to create a access data base to record the information.
I have created a table with the fields below for material entry.
Lab_Sample_ID
Supplier
Sample_Name
Sample_QTY
every time the samples are out, i should be able to record the information using form and reduce the sample_QTY and the total stock to reduce.
similar way to update the stock if the material is in to store,
I have 2 more tables created to record the out and in of the material
Lab_Sample_ID
Sample_Qty_out; Date
Lab_Sample_ID
Sample_Qty_In; Date
Kindly share some code which can do this. Thanks