As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

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

  • Options
    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.