Hello Dore,
I think I would include a create_date field in the table record - use the ATC() function to query the memo field, and set the index to descending/ascending as required

HTH

Pete Kane

e.g. index on create_date tag create_date for (atc('DEATH CERTIFICATE',mymemo) > 0 or atc('BIRTH CERTIFICATE',mymemo) > 0 ). I don't normally advocate the use of the "For" clause with indexes, but depending on the volume of your data set - maybe build it on the fly and use "delete tag create_date" when done


Waiting for the flack