RE: Reordering a file

Joe,

I'm confused a little. You want the items in order by program name,
fine. But do you want to renumber the options so the first is 1, the
second, 2, etc. or not? At first I thought you did, but then you comment
on the ERP system issue of wanting the same # to mean the same thing. 

If you do not want renumbering why not just load the subfile w/a sql
statement, something like:

select option, program, description from menu order by program

Would seem appropriate. If you want it by description, then "order by
description"

What am I not understanding, you should know this. Is this one of those
cases where you're stuck on one solution and don't step back to see
another way (happens to us all) or am I not understand the requirement?

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)