Hi

I have 7 offices that all use my VFP6.0 application.

On one of the views, it is doing a UNION Select statement and then ordering at the end on 2, 4.

The only problem is that on one of the offices fields 2 and 4 are different because of their position in the table.

I understand that the short-term solution is to change the view so that it orders correctly to that particular office, but I would rather know a way of avoiding this issue completely?

Anyone?
Cheers
Kev