<< Is there any way to have the listview refresh but remember the sort that the user has selected? >>
You must code for this. You can get the name of the column the user has sorted on from CURRENTSORTORDER (or something similar, I don't have R:Base open at the moment). You must then modify the LOOKUPWHERECLAUSE to change the ORDER BY to match what the user requested. The problem is that if you're using "automatic" refreshing (where you use a variable in the LOOKUPWHERECLAUSE) then you may not have an opportunity to make this change to the where clause text. I use manual updating, where I rebuild the LOOKUPWHERECLAUSE with the literal value the user entered and, at that time, I make the ORDER BY part conform to whatever the user had clicked on. I have a stored procedure that does all this automatically and will try to remember to post it to the list when I boot up my computer a little later. -- Larry
