Creating a hierachical database using MS Access 2000
Posted on 2001-07-02
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.