How to Check Limit

[needadvice]

I have an assignment table in which I need to assign employees to projects based on a percentage of thier time using a certain skill. Each employee has a limit of time for each skill. This limit is set in an employee table. For instance I'm assigned 50% of my time to Access programming.
Assignments are then made in an assignment table and the amount assigned is then subtracted from the employees maximum time.
After I assign an employee to a project, I need to check the employee table to make sure I'm not exceeding the employees maximum time for that skill. ie in my case more than 50% access programming. I need to raise a message on update of the %assigned field to alert that the assignable skill is over max.
How do I write the code to check the employee table and see if I'm over limit.
Hope I explained this clearly enough.
Thanks for any help

 

[koala15]

A suggestion:

Instead of launching straight into VB code, construct an appropriate DB schema and an old fashioned flow chart. Once both work then write your code and generate your DB.

Cheers.

"Life is full of learning, and then there is wisdom"