Lookup Order

[Mary Ann]

I have a table of people and a table of companies. The
people table looks up the company name from the company
table. I want the company name lookup to be in
alphabetical order of the company name rather than the
primary key value. I created the lookup using the Lookup
Wizard.

Is it OK to click on the build button (...) in the Row
Source and just put the Company Name field in the SQL
Statement into Ascending order? This works but as I
don't work with SQL I want to check out that I'm not
messing anything up.

Thank you in anticipation

Mary Ann

 

[Jeff Boyce]

Mary Ann

Using the built-in Lookup Wizard will cause you headaches (just scan this
newsgroup or Google for "lookup"). Here's a list of reasons you really
DON'T want to be using it:

http://www.mvps.org/access/lookupfields.htm

Also, I'd suggest working in forms, rather than tables, as the forms have a
very rich Event mix.