Access Database help!

R0land1188R0land1188 Registered User regular
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.

steam_sig.png
R0land1188 on

Posts

  • CantidoCantido Registered User regular
    Do you have your list of form variables and table elements?

    3DS Friendcode 5413-1311-3767
Sign In or Register to comment.