It should be possible. Exactly HOW you would do that would depend on the structure of the tables in your database.
Basically you enter times into the Hours window and it calculates the final price based on the cost per hour figure. More than that I can't say as I didn't create this database. I just thought it could be an option in Filemaker, like a reminder or something.
Sounds like an advertising agency or design firm job management system.
The database administrator could send a message using the FM Server to one user or a defined group.
Or turn a Job ID Number Red in the daily job status report.
You are correct, we are a design agency. I was hoping there was an automated way to set a limit in either hours or dollars which warns the staff member if they are getting close to reaching that.
There is a way to do this, but if you cannot describe the design of your database tables, it's pretty difficult to describe for you how to set this up.
There should be much more to this than just entering hours into a field. Somehow, the user must also indicate the specific project against which the hours will be "charged". And whether a single record is used to record all hours worked on a project or a series of records is a very important design detail.
To piggy-back onto Phil's remarks:
Do you have the variances of hours (actual to budget) currently calculated? Same for the actual dollars of the project to the budget?
When actual information is entered to the system, do flags pop at that point to let someone know that an invoice or allocation JUST entered through the project over budget?
These are the type of structure questions that are needed to fully answer how to do what you want?