<div>
mdrake:<br />
<br />
Did Nosterdamus' answer help? If not, please post again.<br />
<br />
Thanks!<br />
<br />
Joe<br />

</div>


mdrake:

Did Nosterdamus' answer help? If not, please post again.

Thanks!

Joe


<div>
mdrake has not returned to EE since he posted the question. Points will be awarded to Nost' unless mdrake returns with a viable objections.<br />
<br />
thanks!<br />
amp<br />
community support moderator<br />

</div>


mdrake has not returned to EE since he posted the question. Points will be awarded to Nost' unless mdrake returns with a viable objections.

thanks!
amp
community support moderator


<div>
Points to Nost'.<br />
<br />
amp<br />
community support moderator
</div>


Points to Nost'.

amp
community support moderator

<div>
<div class="content wysiwyg-content">
I am trying to design a database to store information based on a hierachical structure. &nbsp;The database needs to record which sales rep introduce who and how much comission is due to them. &nbsp;Example: &nbsp;3 reps A, B, C. &nbsp;If A intoduced B, then A gets 15% of B's sales and if B introduces C then B gets 15% of C's sale and A gets 10% of C's sale. I have create a table to record all the details of each rep with a column for [Referred By] to establish a link. I then exacted all the reps whose [Referred by] column was blank into a seperate table. The problem I am having is how to structure the various tables in order to create this relationship between the various levels and identify a path between reps. I was wondering if anyone would be able to assist me on the best table structure in order to achieve this hierachical database.
</div>
</div>


I am trying to design a database to store information based on a hierachical structure.  The database needs to record which sales rep introduce who and how much comission is due to them.  Example:  3 reps A, B, C.  If A intoduced B, then A gets 15% of B's sales and if B introduces C then B gets 15% of C's sale and A gets 10% of C's sale. I have create a table to record all the details of each rep with a column for [Referred By] to establish a link. I then exacted all the reps whose [Referred by] column was blank into a seperate table. The problem I am having is how to structure the various tables in order to create this relationship between the various levels and identify a path between reps. I was wondering if anyone would be able to assist me on the best table structure in order to achieve this hierachical database.

Creating a hierachical database using MS Access 2000

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.