FileMaker 6.0 I'm sure I'm missing something simple here...
For a group I'm in, members ("Person 1", "Person 2", etc.) can volunteer for areas of expertise. Some select several, some none.
I've got it set up with the "area" field being a value list where they can check as many as they wish. (That way it's easy to add or delete areas as appropriate>0
I want a report like this: Area A (with it's name) Person 1 Person 3 Person 4 Area B Person 3 Area C (none) (or, better yet, have "Area C" not even appear) Area D Person 1 Person 2 Hopefully the above is clear as to what I want. But I can't seem to get it! Any help appreciated. Tom Burton
