>Wake up you lot and stop this incessant arguing: I've got a problem for you! :-)
>
>I've a form based on the COUNTY table. Now each county has a number of DISTRICT and ZONES records, ref'ing it by the county code NUMERIC FK (1-m).
>
>On the form there are 2 pages, each with a grid, to show all the zones and districts withing each current county, respectively.
>
>In the DE I have the order of both these tables set to their DESC field and nothing in code in the form alters this. I use the old trick of making both the tables the master, and the COUNTY table the child, so that as I skip through the COUNTY table I get the list of each within it automatically
>
>Trouble is, the District list is in the correct DESC order but the Zones table is higgledy-piggledy order.
>
>Any ideas what's amiss?
"DESC" as descending or description?
And I'm not quite sure what do you mean by master-child here... do you mean the grids' recordsources are zones and districts respectively, and you got the county related into each (additive)? And if so, related via what field?