>Hello all,
>
>I'm using fox6 on this. The current code has:
>set order to lname
>locate for lname=alltrim(name_sel) .and. fname = alltrim(fname_sel)
>
>However, the user would like the results to be abc order by lname then fname. What is the best way to do this?
>
>I thought about:
>index on lname + fname to full_name
>set order to full_name
>but this ended up giving me an msgbox everytime the page was run asking if I would like to overwrite full_name.idx.
>
>Thanks again,
>Sunshine

Sunshine,

You only need to INDEX ON once in your application. After that you can just use SET ORDER to have the list reordered. You will not get the message this way.

Renoir