Lookup fields are of VERY limited utility: they make it a couple of
mouseclicks easier to add a Combo Box to a form, but that's about it.
See http://www.mvps.org/access/lookupfields.htm for a critique.
Join the lookup table to the table you're trying to sort, and sort by
the text field from the joined table.
