I am trying to program a form/subform in a database for a recycling center.
I have a main form which contains next to no information of necessity to my question, but is basically to create a Purchase Order and Receipt.
The subform has information with a date, product ID, rate, weight, and subtotal. I need it to find a rate in a separate table based off of the date & ID, and multiply that rate with the weight to get a subtotal.
If anyone would be willing to point me in the right direction I would appreciate it, I just have no idea at the moment where to even begin.
EDIT: I had an epiphany, I was seriously over thinking the issue. I setup a rates sheet that updates the table with the proper information.