>Can it be done without creating a view?
The view is the most straitforward way to do this IMO.
With the view already ordered you can use it like a table directly in your form.
You can use the relation or a select instead of a view, but you cant create an index on two tables.
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