Microsoft Access 2007 Update fields

[ruralguy via AccessMonster.com]

Have you created a query that joins the two tables on Dept yet?

The name are the same in both tables. The dept table is for inputing
information,
the user does not want to lookup the data she needs to put in.
if she knows the dept nbr she wants it to put desc and glcode that match
that dept.
The coorsponding field are all of the same data type.

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same

[quoted text clipped - 10 lines]

 

[Thel]

I have made a query with all the fields. Should I delete the dept desc and
glcode from the employee table and then do a join on the fields. If they are
not stored in the database employee how will I use them to print on reports?

Have you created a query that joins the two tables on Dept yet?

The name are the same in both tables. The dept table is for inputing
information,
the user does not want to lookup the data she needs to put in.
if she knows the dept nbr she wants it to put desc and glcode that match
that dept.
The coorsponding field are all of the same data type.

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same

[quoted text clipped - 10 lines]

Any help would be greatly appericated.
Thelma

 

[John W. Vinson]

Should I delete the dept desc and
glcode from the employee table and then do a join on the fields.
Yes.

If they are
not stored in the database employee how will I use them to print on reports?

By basing the Report on a QUERY joining the appropriate tables.

If you're assuming that a report must be based on a single table, you're
making a very common mistake... but it is a mistake.

 

[ruralguy via AccessMonster.com]

Only delete the duplicate fields after you are comfortable with the fact that
using a query with a join makes the fields available any time you want.

I have made a query with all the fields. Should I delete the dept desc and
glcode from the employee table and then do a join on the fields. If they are
not stored in the database employee how will I use them to print on reports?

Have you created a query that joins the two tables on Dept yet?

[quoted text clipped - 10 lines]

 

[Thel]

Thanks I think I have It.

Only delete the duplicate fields after you are comfortable with the fact that
using a query with a join makes the fields available any time you want.

I have made a query with all the fields. Should I delete the dept desc and
glcode from the employee table and then do a join on the fields. If they are
not stored in the database employee how will I use them to print on reports?

Have you created a query that joins the two tables on Dept yet?

[quoted text clipped - 10 lines]

Any help would be greatly appericated.
Thelma

 

[ruralguy via AccessMonster.com]

Great! Thanks for posting back with your success.

Thanks I think I have It.

Only delete the duplicate fields after you are comfortable with the fact that
using a query with a join makes the fields available any time you want.

[quoted text clipped - 8 lines]