Newbie needs some help

[cbosse]

I'm developing a database that tracks monthly metrics of employees. These employee are at several different locations.

Here's what I would like:

A table of the employees and their location.
A table of the metrics.
A form that you can select an employee and it would autofill the location and then you could fill out the metrics.
the ability to change an employee's location without it effecting past records.
A report, by month and location of the employee's metrics. (pretty sure I can do this on my own, just can't get to this point.)

I've tried to use a auto lookup query but that then changes the employees location on past records.

 

[burrina]

If the combo uses both tables, this should be no problem and of course they are correctly linked. You can bind the controls to the Column of the query for the combo.This is just one way!

HTH

 

[cbosse]

Sorry, don't quite understand what you mean by binding the controls.

 

[burrina]

That means each field should have a control source.

 

[Dinger_80]

Have you looked into cross tab queries? I use them to do metrics on quantity of testing performed. The user selects a year which is a combo box. It still comes out looking like a query but is very easy to read and understand.