LookUp

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

Guest

H
I have two tables that are related. Table one = Employees, Table two = Training that employees have done

I have made the namefield a lookup field to make it easier to enter the training. ( eg I don't have to enter the name manually all the time). However, when I lookup a name it is not in alpha order but is sorted on the related "Employee Number"

How can I make it display in name order?

Thank

Any help would be much appreciated.
 
PJ said:
Hi
I have two tables that are related. Table one = Employees, Table two =
Click to expand...
Training that employees have done.
I have made the namefield a lookup field to make it easier to enter the
Click to expand...
training. ( eg I don't have to enter the name manually all the time).
However, when I lookup a name it is not in alpha order but is sorted on the
related "Employee Number".
How can I make it display in name order??

Thanks
Click to expand...

Go to the row source for the lookup and click in the right margin. This will
open the query the lookup is based on. Add a sort option to one or more of
the fields.
 
Hi
I have two tables that are related. Table one = Employees, Table two = Training that employees have done.

I have made the namefield a lookup field to make it easier to enter the training. ( eg I don't have to enter the name manually all the time).
Click to expand...

If you use a Form with a Combo Box on it, you won't need to enter it
manually. Table datasheets are VERY LIMITED in their capabilities, and
should not be used routinely for data entry - use a Form instead.
However, when I lookup a name it is not in alpha order but is sorted on the related "Employee Number".
Click to expand...

Exactly. Microsoft's misdesigned, misleading, obnoxious so-called
Lookup misfeature (see http://www.mvps.org/access/lookupfields.htm for
a critique) is *storing* the Employee Number in your table, *and then
concealing that fact from your view*. It LOOKS like you have the name,
but you don't.
How can I make it display in name order??
Click to expand...

Get rid of your Lookup field, for starters. Then create a Query
joining Employees to Training by Employee Number. Sort this query by
name, and display whatever other information you would like.
 
Back
Top