Sort a report by a hidden field in a combo-box

[mkj]

Hello,

I have a report which displays a list of devices, and their current
location. The table is:
Site, Description, Serial Number.

Site is a number which has a relationship to the SiteNo field in a Site table:
SiteNo
Name

This table is not arrange alphabetically. Record 1 may begin with "A", 2 may
begin with "Z", 3 may begin "M" for example.

The Site name in the report is a combo box, with two columns. The first
bound column is the site key. This column is hidden. The second column is the
true site name. When I order it by site, it is ordered by the hidden key, not
the visible name. Hence results do not come out alphabetically. Is there an
easy way to sort by the second column of a combobox?

Thanks,

Mike

 

[Duane Hookom]

I would add the Site table to your reports record source so you could:
- sort by SiteName (Name is not a good name for a field)
- replace the combo box with a text box bound to the SiteName field