By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,661 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,661 IT Pros & Developers. It's quick & easy.

Heirarchal relationships

P: n/a
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.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.