Appending data from one table to multiple relational tables

[Ken Snell]

If you're not able to update/change the employee info, then either
(1) the control isn't bound to the employee field in the form's
recordsource; or
(2) you're not using an appropriate query as the row source for the
combo box control that has the employee info (e.g., your control is trying
to put an employee name into the field instead of the employee ID).

Give info about what type of control you're using for the employee info,
what is its control source, what is its row source (if it's a combo box),
what is its bound column (if it's a combo box), etc.

 

[Ken Snell]

It depends. Will any other table's info be wanting to use site / location
information besides the employee table? If not, then putting it into the
employee table would be fine -- it is denormalizing the table structure, but
in this case it's probably appropriate to do that.

 

[Stranger]

Ok, I thought maybe you got tired of me.

As far as the locations, I don't want to denormalize. I want to try and
stay with appropriate standards.

any idea why the fields are not changing? I changed the form to the type
you suggested but that makes all records down one page. Kind of messy.