AnsweredAssumed Answered

Use list values to group records FMPro11?

Question asked by leebrock on Feb 10, 2014
Latest reply on Feb 11, 2014 by leebrock

Thank you for your help.

 

I am sketching out a little data base for the real developers to use as an example of what we need.

 

I have a single file DB with contact information on each service provider. One of the fields is SERVICES which contains a checkbox value list of 10 different services a service provider might offer. One could check any number of services or all of them.

I've created a staff directory layout which I can sort by last or first name and I also need to be able to group the directory by category, i.e., each value held in the list in the field SERVICES would be a single category.

 

I have a layout part, (sub-summary when sorted by SERVICES) above the list of names in my directory layout to group the categories but it's not working. The way it is intended to work is that each category header (values from SERVICES) would be listed with each provider who has that value checked, listed under the summary header. If a provider does 5 services, they will show up under all 5 categories from the checked values.

 

Service Directory

Service 1

Joe*

Jane

Bob

Sue

Service 2

Joe*

Sue

Service 3

Joe*

Bob

Jane

*Joe shows up in all categories.

Thank you for your help.

Outcomes