>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
How do you know which is which?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.