Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to do a weird ordering of data
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to do a weird ordering of data
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01510568
Message ID:
01510568
Views:
126
I have been asked to order a set of insurance records as follows:

Insured
Spouse
Child 1 Oldest
Child 2 Next to Oldest
Child 3 Youngest

I know that I can put the children in order by their birth dates, but how do I order the data to get the Insured Member first and Spouse 2nd and then the children by birth dates? Is this do-able?

I cannot do a simple index, it appears.

Cecil
Next
Reply
Map
View

Click here to load this message in the networking platform