Custom sort with a value list
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:
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:
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?