I created the following view and the ORDER BY settings don't seem to be working... (it was originally created with the Wizard then modified)....
SELECT Employee.employeeid, Employee.lastname, Employee.firstname,;
Log.employeeid, Log.firmid, Log.codeid, Log.logdate, Log.time, Log.rate,;
Code.codeid, Code.codenum, Code.codetype, Code.codedesc;
FROM timepro!employee INNER JOIN timepro!log;
INNER JOIN timepro!code ;
ON Log.codeid = Code.codeid ;
ON Employee.employeeid = Log.employeeid;
ORDER BY Log.firmid, Employee.lastname, Employee.firstname,;
Code.codenum, Code.codetype
When I BROWSE the view, the only part I can find in order is the CODENUM and CODETYPE fields.
Also... when you use a view on a REPORT and in the report you set up some data grouping, does that override the ORDER BY of the view?
Thanks
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!