I am having some major issues with this component of my db. I will try to be as detailed as possible, sorry if it is confusing.
I have two Tables -
Transaction Log (Transaction ID, Serial Number, Model, Date, Time, Total Prints, Total Copies, Total Scans, and Total Count) and
Main (Serial...