Assign a $$ to an Employee

OK...this is going to be a bit tough to explain...

I made a great database to track our jobs and the time each department spends working on their part of the job.
I was even able to assign a $$ amount that is charged when a department does work on that particular job and
multiply it by the # of hours input into that department. That was actually very easy. The problem is, sometimes
a person from one department has to do work in another department to help complete a job on schedule. Although
the department charge is say...10.00 and hour, the person from the other department is charging our client his rate
of 20.00 an hour. (his departmental rate)

How can I ... When I input John Doe as the employee, ensure that his rate will apply no matter what department
he is working in?

I assume I will have to change the entire workings of the database, but I am OK with that.

I will now stop posting my insane questions and continue trying while I wait for your input.

Thanks for all of your help.

Gale - Uber Newbie.

I believe if you will set up your tables in the one to many relationship I believe you can solve what you are after. One Job can be assigned to Many Departments and each department can have many employees. You could go one step further and build a table for groups. So that one job is assigned to one group and can have different employees from different departments in which for each department has it's own hourly rate. From what I read, I don't think you will have too much trouble converting the relationships together, most likely adding the necessary matching ID fields and then link them together in the relationship window will be all that is required.

My idea anyway,
lwells

Something just flew over my head...lol...it was your answer.

I understand a little about relationships and tables, but not nearly enough. I will keep reading my "How to do anything with Access" book, and reading these posts and looking for sample databases. I will get it eventually.

Thanks

Gale - Uber Newbie

Is there a chance that you could give me an example of how I would do this? When you say it, it sounds easy, but I can not make it work. Hrumph!

Hi Gale,

Sure be glad to help you out. Why don't you make a back up of your database and strip out everything except the related tables and form that you are working with and zip the database to me by email, and I will look at the tables and get it working for you.

email Lwells1433@aol.com
lwells