Need to increment a Value in a table.

[raydan]

I have a database that has a few tables and in one of them (Originators), there is all the info about my loan originators including there comission level. I would like it when they turn in a certain amount of loans there commision level will increase. Is this posible? Here is my DB setup.

Tables:

Originators- 1 to many-
OriginatorID,FirstName,LastName,OrigSSN, Address,City,State,PostalCode,HomePhone,WorkPhone,CellPhone,FaxNumber,EmailName,BirthDate,Level(This is the commision level, and its in %).

Customers- 1 to many-CustomerID,FirstName,LastName,SSN,HomePhone,MobiPhone,FaxNumber,Address,City,State,Zip,Email,BirthDate,CreditScore,SpouseFirst,SpouseLast,SpouceSSN,SpouceBirthDate,SpouceCreditScore,OriginatorID.

Loans- many to 1-
LoanID,LoanType,StartDate,EndDate,LoanLender,CustomerID.

Lenders- 1 to 1-
ID,LoanLender.


When a customer is added to the DB it is done with a form that has OriginatorID(which is autocreated), CustomerID(also auto) and some other of the customer stuff like phone numbers. When this happens I would like to have the originators % level increase, say after every 4 customers entered. Is it possible?

Thanks,

Scott

 

[llkhoutx]

Mere increment won't work because of the potential for deleted records. Just count the appropriate records.

 

[raydan]

Your correct it is a great deal. Just let me know and I can get you set up anytime. Financialy this Corporation is very strong working from this model. Maybe your in the wrong business because the branch manager is making 45k a month. Getting people to sign up is not as easy as you think, when your dealing mortages, Insurance, and securities. I was just trying to see if there is a way to make tracking our loan originators progress easier. I will continue just watching how many new customers and loans they produce and then change the commision levels manually. Also, sorry about posting this in another forum catagory, I just wasn't sure whick topic to post it in. This site is great and very helpful.

Scott