LookUp

[PJ]

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.

 

[Mike Painter]

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).
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

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.

 

[John Vinson]

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).

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".

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??

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.