Skip to Content
Former Member
May 19, 2016 at 06:11 AM

Link Multiple Field to Same Table with Summary


I have a table JobOrder which has the fields CommissionStaffID1 and CommissionStaffID2 which link to the table Staff via StaffID.

What I would like to do is summarise each Job Order by the StaffID whether they be CommissionStaff1 or CommissionStaff2. The purpose is to be able to calculated commission to consutlants and oftern a Job Order has split commisssion.