Robeito -

Like John said, add the Country table to the query behind the form and use
that name in your form. You can hide this field if you want and still sort
on it, so the user interface is the same as what you have. Or, if the form
is not meant for updates, you could remove the combo box and just show the
country name.

--
Daryl S


"John W. Vinson" wrote:

On Tue, 4 May 2010 13:04:01 -0700, robeito
wrote:

Thanks Daryl:

I must clarify my post:

Actually the data grid shows the information as I spected, but, when I use
the standar right click action of the mouse on the grid (sort A-Z, sort
Z-A, cut, copy paste, filter,...) and use the sort option, the grid is
sorted by the countries ID and that's not what I want, I want the grid sorted
by the alphanumeric name of the country

Then you will have to base the datasheet on a Query including the country
table.

The combo box is not data, is not part of your table, and is not something you
can sort: it's just a display tool, displaying data from *a different table*
(the combo's rowsource).
--

John W. Vinson [MVP]
.