Autopopulate data in one cell based on data in another

[BRAY1980]

Hello.

I am trying to create a database for my organization that keeps track and calculates weighted percentages, etc.

My current problem is that I need to create a table and, eventually, a form where the user selects the task s/he has completed which will prompt the appropriate goal per hour in another cell.



Filing, for example, has a goal per hour of 175. Currently, we are using Excel spreadsheets to keep track of this data. The user enters the time spent and actual numbers produced. To produce the percentage, the formula is Actual Numbers/(Goal Per Hour * Hours Worked). I would need to mimic this in Access. I've already set up a table to house the tasks completed in our department along with their corresponding goals per hour. I'm now in the process of creating a new table (so that I can create a form) and need that functionality where when a task is selected, the GPH is autopopulated.

Thanks in advance!

Bray

[hertfordkc]

One table contains task (Filing), Result(Count),and Hours(worked).
The other table contains the list of tasks and the corresponding goals.
A query could tie the two tables together and produce the calculated result.
The calculated result could be stored, but probably shouldn't be.
Let us know if this doesn't satisfy. If it does, please mark the post as solved.