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?
'ppreciate it
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.