shuffling most recent to top

[aytab]

I create small in/out reports for different items much like a library or video store (they are created in a separate database but share an inventory number relationship, since I will create multiple in/out reports for a single item in the database), and wish to have them listed in the main database in one field totrack activity and see when something is in house or checked out, but I can't seem to get the most recent one to show up in the field window, it always defaults to the oldest, how can I adjust it so that it shuffles them into order showing the newest on top and the oldest on the bottom?

[bcooney]

I think you might get a reply to this if you specify your file names (FM6), fields and the relationships that you have.