Perhaps, this may be a silly question, but how do I run a MakeTable
query but only copy the records instead of moving them?
My main question though: I have a cascading relational database. Think
of a company structure- First the boss, then below him department
heads, then below them managers, etc etc. Like a branching diagram.
Now I want to run data up the tree. Based on the position(stored in a
field)of one person, two people above get a commission based on his
sales. The position of the person, and the people above, is the basis
for deciding the rate. If that wasn't bad enough, if the person above
is not of the required position, it must go up to the next person, but
only until 2 people above get the commission.
Let me try to give an example, using 2 positions.
DIS is the lower position - A DIS Above a DIS gets 0% commission
PRE is the higher position - A PRE Above a DIS gets 25% commission, a
PRE above a PRE gets 8% commission
Picture this- up is this way ->
DIS -> DIS -> PRE -> DIS -> PRE -->
$100sales>0 >$25 > 0 > $8
I don't have much experience programming anything for databases, but I
do have quite a bit of database experience. I have queries that tally
up the sales for each member, its just the commission thats a bother.
I have searched many places and racked my brain but been unable to
come up with an answer.