Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

Relating a maximum % for a value to change from one table to another

I've got a table of "Materials" with a field for "Cost" of each material. I want to be able to structure this so that anytime the cost of an item is modified, it cannot be modified by a maximum percen...
Relationships
NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago
Thanks, Mark.

I've got it set up so the way you outlined it and I'm able to pull in the Active % down to the Materials table. 

The issue I am having now is that if the user changes the Active modification % to a different record in the Material Costs Modifications table how does the Focus Max record update accordingly as well? Will the user have to update which % the want to be Active in the Material Cost Modifications table and then edit the Focus Max record as well?


ᐧ


MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
When you edit the focus max record to select a Max, it will flow to every Material Record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • NirajShah4's avatar
    NirajShah4
    Qrew Cadet
    5 years ago
    I appreciate that, Mark. As always, a simple solution that works exactly as intended. 

    Thanks,

    Niraj