It works but........

  • Thread starter Thread starter Angela M
  • Start date Start date
A

Angela M

Sorry for the new thread.
Thanks to Steve for his help. I now have a form based on a query and a list
of names and employee ID's.

When you enter the employee ID on the form the First and Last name fields
update.

The problem comes when add a new record via the form all the data enters
into the correct table except for the first and last name. This makes sense
to me as these two pieces of data are referenced from a different data
source.

The question is, how do I get the first and last name data from the employee
names table to enter into the employee data table via my form.

Cheers
TM
 
Angela,

Sorry for the new thread.
Click to expand...

No problem, except:
- only people who have been following the previous thread will have
any idea what your post means, and
- putting it in a new thread reduces the probablility of finding it
...
The question is, how do I get the first and last name data from the employee
names table to enter into the employee data table via my form.
Click to expand...

You can't and you shouldn't. As mentioned in the other thread, I
think it is best if you post back with details of the two tables.

- Steve Schapel, Microsoft Access MVP
 
how do I get the first and last name data from the employee
names table to enter into the employee data table via my form.
Click to expand...

The answer is:

YOU DON'T.

Relational databases use the "Grandmother's Pantry" principle: "A
place - ONE PLACE! - for everything, everything in its place".

If you have the employee name in the Employee Names table then *that
is the only place your entire database should have that name*.

Suppose Jim Jacobs gets married, and he and his wife change their last
names to Jacobs-Schmidt? If you have copied the name into a dozen
different tables, you now have to track them all down and change them
all.

If you want to see the name in conjunction with employee data, USE A
QUERY joining the two tables - that's what Access is designed to do!
 
Back
Top