First of all, I wanted to say that everyone on this forum is amazing and has been soo helpful.

Here's my dilemma.

I'm working on a commissions database for our sales department. Right now, whenever a radio box is checked as a recoat, the commissions will zero out since they can not recieve commission on a recoat.

Our problem lies whenever we credit someone for the bad material but then they want a recoat, so then we have to charge them for it, which would recieve commission. But that job would still be considered a recoat.

I would like to have a drop down list that would say "commissionable" if there is no recoat and "non commissionable" if there is a recoat. I would like this as a drop down list just so that we can change the commission status. So that in the rare cases that the above instance occurs, we can mark the job as a recoat, but then change the status to "commissiable" and the commission field will draw in teh amount of commission again.

Any clues?

Thanks for the help!

-Robin

I would have a flag field in SaleLI flag_IsCommissionable. It is either 1 or nothing. Assign a value list of 1 and format as a checkbox.

Now, this idea of recoats. Recoats are an item that can be sold? If so, why not go back to the Parts (Items) table and create a field flag_IsCommissionable. Again a value list of 1 and format as a checkbox. For every part, indicate is commissionable status.

So, when you create a saleli, and enter a part#, it's commissionable value is looked up from parts into the SaleLI flag_IsCommissionable field. It can be deselected at the time of sale.