>How would you write and index expression for a table using its foreign key but ordering it by the descriptive text field the key relates to in anonther table? In other words, the incidents table has an employeeid field that can be related to the employees table by saying incidents.emloyeeid = employees.employeeid. The employees table has first name, last name ect. I simply want to set the order of the incidents table to last name.
>
>Thanks for any help.
Create a view with both tables and order it the way you want...
:-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca