I want to track the Lot Number of a Receiving Data base which I log all materials that are coming to our Warehouse. Every production I issue a Inventory Card for each material they needed, where they write the Quantity they dispense and the Lot Number of Material where they used it, the Date and the Quantity Remaining.
Below are the fields of my Materials Table
|Material ID||Text||Index; Auto Enter Serial|
|Quantity on Hand||Calculation||Quantity Received - Quantity Used|
|History ID||Text||Index; Auto Enter Serial|
|Lot Numbers Used||Text|
|Card Issued Date||Date|
|Card Returned Date||Date|
Can you please help me setup the relationship ; and please suggest fields that can also be included.
Thank you so much to any help and suggestions for the development of my project.