Hi, I am a FM newbie.

My database is a simple contact list, from which I create mailing labels.

I have my contacts categorized for a main category ("category 1"), then a sub-category ("category 2").

I would like to not only sort but create a temporary, isolated or standalone list, so when creating mailing labels, only those relevant contacts are included. I do not want to just rearrange the whole database because quite a few records are irrelevant for certain lists.

The sorted listed would only include A and 1, or A and 2, or A and 3. Or B1, B2, B3. Does this make sense?

I have only been able to find sorting help (from "Help") referring to rearranging the order of the entire database, whereas I would like to create isolated, sorted lists meeting the particular category requirements.

Thank you I would really appreciate some advice!

First you need to do a search to find the records you want then you can sort the "Found Set."

Assuming that you are searching one field "Category", create a script including "Category" in it so user can choose the correct data like so:

Show Custom Dialog( "Enter correct data"; :Category) /*You enter the Input field under the "Input Field" tab.

If(Get ( LastMessageChoice = 1))

Go To Layout (Reportlayout)

Enter Find Mode()

/* Uncheck pause

Set Field(::Category)

Perform Find()

Sort Records()

End If

If(Get ( LastMessageChoice = 2))

Exit Script

End If

I didn't check this script so there may be a couple of bugs, but I hope it gives you the general idea.

HTH

That is kind of hard to follow... I'm in the Edit Script dialog, I can select many scripts but as far as I can tell I can't cut and paste what you have provided.

I'll keep trying to figure it out but it's probably going to take a while.

thanks