Hi, I am a newbie to FM. I have a simple database as a list of contacts.

I would like to sort the list and separate the results, from where I will then convert it to a mailing label layout.

This way I can sort the relevant names and generate mailing labels without printing out the entire database.

For example, say there are 100 names in my contact database. For the purpose of creating mailing labels, I want to sort 40 (or any number, it's arbitrary) onto a separate list to then generate the labels.

Basic sorting seems to only reorder the entire database. There is probably a Script to achieve this, but I can't quite figure anything out.

Thank you.

Sort Records []

Omit Multiple Records [40]

Show Ommitted Only

This will sort the records, in the order that you want, then will show you the first 40 sorted records.

thanks...that's a step in the right direction. Only, the number will change as I add records. So I shouldn't specify a number to omit, because it will gradually change.

I would like to sort based on a "Category " field, (there is also a sub-category: "Category 2", but that for later).

In the Scriptmaker I am trying to figure out how to sort, and "show only sorted" or "omit non-sorted." Something like that.

By the way, what does "MOVED:..." added in the title mean? If this is not the right plaace to post this topic where would it be moved to?

Thank you very much...

The number that you want to display can be scripted. The steps that I posted earlier was only to show you the technique.

When sorting records, it sorts the Current found set. If you add a new record, it will not be automatically sorted upon committing.

As for your question regarding the MOVED, the moderators of these forums may move threads that may be misplaced into the appropriate areas.

I'd suggest you begin with FINDING the records you want. Then sort them, and go to a layout for printing. All this can be done automatically in a script.

wow I think after all the confusion and nailbiting, I think the Find option is what I need. I can specify the fields, then it creates just that list.

New problem, after I get the correct list, I generate the mailing labels, it looks fine. But when I print preview, only the first record shows up. Any possible reason for that?

Thanks for the help.

I figured out the printing issue - it's in the print dialog box, print "Records Being Browsed".