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