> SNAME=STREETNAMES.SNAME, COMPLAINT.ADDRESSNO;
> RESOLUTIONDATE=COMPLAINT.RESOLUTIONDATE, STREETNAMES.SNAME,
> COMPLAINT.ADDRESSNO;

> Ordering Links:

> SNAME=ITEM=1
> RESOLUTIONDATE=ITEM=2

It should work, although you may need the table name in the ordering
links.

When you say that the secondary items have "no effect", what do you
mean? Could it just be that the order is unexpected due to character
case or perhaps character set?


--
Geoff Worboys
Telesis Computing