thong127

How to make a History Log

Discussion created by thong127 on Oct 6, 2015
Latest reply on Dec 15, 2015 by thong127

Hello All,

 

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

 

FieldsTypeOptions
Material ID TextIndex; Auto Enter Serial
_id_constantCalculation=1
Material NameText
Material LotNumber
Quantity ReceivedNumber
Quantity UsedNumber
Quantity on HandCalculationQuantity Received - Quantity Used
Supplier Text
ManufacturerText
Manufacturer LotText

 

Lot History

FieldsTypeOptions
History IDTextIndex; Auto Enter Serial
_id_constantCalculation=1
Lot Numbers UsedText
Card Issued DateDate
Card Returned DateDate

 

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.

Outcomes