implement a variable commission rate calc

[skingjack2]

Hello all,

Any quick thoughts on how one would go about implementing a variable commission rate calc. i.e. each product sold has different commission rates. I'm envisioning a solution where once a

total value is entered into a field, another window would pop-up where you would choose the appropriate commission value and then the calculation would execute with the final result

placed in another field. Creating a new display

is not an issue; it's just integrating the calc with the display is the stumbling block. As with our questions I've posed, there always seems to be more than 1 way to accomplish things in FM...I'm open to other suggestions/ideas.

TIA

Jack

[skingjack2]

Hi,

Did a little more searching in the forums and I think I may have found another solution though not quite what I envisioned that will work .

(thanks comment for your related value file)

Jack

[comment]

I am not sure which file/thread you are referring to, but it sounds like in this case a lookup would be more appropriate than using a related value directly. This way, if a product's commission rate changes, previously created sale records will not be affected.