I'm getting a headache trying to figure this out, so I'm hoping someone can help me here.
I have commission that I need to pay out to salespeople. Each salesperson has his/her own unique rep number. At the same time, there are also rep numbers that are shared by two or three salesperson. Is there anywhere I can have a lookup table to split the commission that's associated with a shared rep number so that access know to allocate 50% of the commission to a none shared rep number and 50% to another?
Thanks.