Set up linked record for variable costs

I have a base with labor rates, which can vary depending on retail / wholesale, etc … screenshot 1

That table links to another table in the same base, which has a variety of categories. Might price category 1 at List Price, category 2 at 10% off, category 3 at cost +10%, etc … screenshot 2

Is there a way to have one “base rate” amount, and then have the variable rates calculate based on that? Right now, I just input them each manually. Would be nice to change the “base rate” and have all the variables automatically update. I realize I could do this in multiple fields, but that won’t give me the ability to have a linked record selection?

Thanks in advance

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.