I'm missing something here and cannot figure it out. Here's a couple of screen shots in my setup. Simply trying to multiply quantity times price to get total.
As long as you have a relationship from Materials_Total to Materials, you can access the price of the material.
The question is: do you want to save it in the Materials_Total table. I think you want to do that. A material's price can go up over its lifetime, and that new price should only be for new jobs, not for old jobs. So storing the current price in the materials_total table is good; that current price represents what it was at that moment in time.
So yes, I'd script the placement of the Materials::Price into the Materials_Total::Price_per_Item field.
You could also do an auto enter calc and set that price as soon as the Materials_Total::ID_Material field is filled in.
What's the problem? The product not showing up?
Doesn’t compute. Nothing shows up in the field.
Sent from my iPhone
Figured it out. My Price field referencing another table which brings up another question. Am I going to need a script to capture the Price from the Material table and place in Material_Totals field Price_Per_Item? Or just not have the Price_Per_Item field.
Here's the Relationship graph.
Excellent point, Jeremy. Will see if I can get that done. Thanks a bunch.
Howdy. Howd things work out for you? Was I able to provide an answer that works for you?
Retrieving data ...