Help Definining Table Structure For A VBA Function

[jessedh]

hello all,

I have to create a database that calculates commissions of sales staff.

There are 6 different 'structures' that can each have different tiers. For example: I can have 2 loan officers on the same structure, but a parameter of the structure is TierA. TierA can be 100,000 for sales person 1, but 200,000 for sales person 2. I would like to define an LO table, a schedule table, and a parameter table.

I currently have this all done in VBA, but it is hard to maintain. Everyone a new sales person is added, a change has to made to the code. I would like to make it more forms based.

My dilemna is that I can't wrap my head around how to set up the tables, since each structure will have a different number and type of inputs.

Any help you can provide would be greatly appreciated

Jesse

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jessedh]

the problem is that it doesn't follow normalization standards. does anyone have any experience with something like this?