Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
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.