Sorting Items on a Screen

Carol Kaffenberger kaffenbe@karmanos.org
Thu, 12 Oct 2000 11:20:24 -0400


We have a screen that sequentially retrieves & displays
records from an Image manual master dataset.
The user selects an entry from the values on this screen and
other programs are called to do the actual work.  There are
more than 30 items on this screen.   We would like the items
to be displayed in ascending order by the index of this
dataset (ID CODE - See below).  I tried to add a sort key to
the dataset via Architect, but sort keys are only valid for
detail datasets.  I tried various ACCESS statements with no
luck.

This is what it looks like now:

               Generic Table Maintenance           10:53
EP8070KS

ID CODE   TABLE NAME                   ID CODE   TABLE NAME
01 TRIC     Tri-County Area City          02 SPAN    Spanish
Surname List
03 SDIR     Street Direction                   04 SIGR
Site Group & Desc
05 OLDS    ICD-I to ICD-II                  06 CTRL    Last#
Comp Assigned

This is what I would like it to look like:

               Generic Table Maintenance           10:53
EP8070KS

ID CODE   TABLE NAME                   ID CODE   TABLE NAME
01 CTRL    Last# Comp Assigned        02 OLDS     ICD-I to
ICD-II
03 SDIR     Street Direction                   04 SIGR
Site Group & Desc
05 SPAN    Spanish Surname List          06 TRIC
Tri-County Area City

Any help would be greatly appreciated.

PH 8.19.C5, MPE/ix 5.5
--
Carol Kaffenberger
Karmanos Cancer Institute
Detroit, Michigan


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.