Showing values based on underlying field data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the query builder, use one copy of your orders table, and four copies of
your employees table (add the table four times). then link each of the four
copies to your four employee fields
 
Let's say I have an "Orders" table w/ a bunch of fields about price, ship
date, etc., but also 4 fields for different employee stuff related to orders
(ie. one employee enters an order, one employee processes the order, one
employee makes what's on the order, one employee inspects the order, and one
employee ships the order).

I have a table w/ employee ID's associated with names, and the numerical
values are placed in the order detail table's 4 fields. However, I want the
form that shows data about order history to show the associated names of the
employees rather than the employee numbers. I tried using relationships and
joins in the query that the form is based on, but I get weird results - no
matter how I create joins, I get either no records or error messages.

I was trying to create the desired result using the joins in the query
builder (ie. dragging "EmpID" over to the several fields of the order detail
table that contained employee numbers in the data), and I also tried using
control sources properties to "calculate" the corresponding employee name
from the employee ID field, but I may be thinking the wrong way when trying
to make this query or the control source properties.

What's the best way to go about showing the employee names associated with
these orders rather than the ID number that's in those fields?

Thanks y'all, appreciate any help
 
Hey, there it is, thanks man. Some of this stuff is so simple but they
don't talk about it in the Help.

Appreciations
 
Back
Top