sorting records in a with view metadata view

[giovi2002]

I'm using the with view metadata clause in views. As a result I can not use order by in the select statement so my recordset will automatically be sorted by the Primary Key.
When showing the recordset in the access client I want it to be sorted to two different fields than the primary. How can I easily achieve this while keeping the recordset updatable? (I also added the view to a stored procedure and queried it as a table using order by, it worked but the recordset wasn't updatable).

 

[giovi2002]

Note:
I also used order by in the view using the top clause, the problem is the recordset won't be updatable. So I need an updatable solution