AnsweredAssumed Answered

Custom sort with a value list

Question asked by Terri on Mar 2, 2009
Latest reply on Mar 3, 2009 by Terri

Title

Custom sort with a value list

Post

Hi,

I admit I am new to FileMaker and currently trying to "self-teach." We do have a consultant coming on board soon, but I am sure this is such an easy issue that I thought I could answer it before he got here.

 

I am trying to create a script with a custom order based on a value list. I have 8 different values:

Core*

Prospector*

Men's

Plus

Liquidations

Home

Kids

Uniform

 

However, when I do the sort, I want it to put Core and Prospector together and Kids and Uniform together, so that when I go to print mode those two categories are on the same page. I have tried a few different things, including:

 

"Core*Prospector*"

Core*;Prospector*

Core*:Prospector*

 

Is this even possible? Or do I need to do Sub-summaries perhaps? Or more than one sort? I know this is easy for those with experience, but the light bulb just isn't going on for me. Any ideas?

Outcomes