Sort Question

[Silvio]

Hello, I have a Combo Box as a Group By item in my Access 2007 report.

The grouping is correct, however the sorting appers to take place based on
the ID Column(0) of the Combo Box insted of actual text Column(1). How can I
force the report to sort by the value and not the ID?

Thank you,
Silvio

 

[Duane Hookom]

Your report's record source must contain the table and field with "the value"
so you can use it to sort.

This seems to be another reason why lookup fields in tables are a bad idea.

 

[Silvio]

Use it or not to use it... that is the question…! (Lookup)
I see some benefit as well problem with it. The positive is that tables with
many stored IDs are easier to read it when you can actually see the data
value instead of a bunch of numbers. Also, when building forms, the combo
boxes are automatically transfer over to the form.
On the negative side, I notice problems with sorting as well performance
slowness, especially when using a dozen of linked tables with a couple dozens
of lookup.
In your opinion when/where lookups (combo box) should be used?

 

[Douglas J. Steele]

You should never be working directly with tables, so your reason that it's
easier to see values isn't really relevant.

In my opinion, you should never use lookup fields in tables. See
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some
other reasons why not.

 

[Duane Hookom]

IMO, don't ever use lookup fields in tables. Also, don't allow users to
access tables. They should ideally work only with data in forms where you
have created combo boxes and other functionality.