Hi Tom
A big problem here is people can belong to more than one area of
expertise ie: have more than one expertise value per record. Standard
summary reports aren't geared for that.
I would consider a separate reporting file here. Isolate records
either using finds or go to related records commands for each area of
expertise in the main file. Then import them into the report file.
That way, the person with more than one area of expertise will have
more than one record for standard summary report purposes in the
report file.
Each time you would run the report, the first step would be go to the
report file and find all records and delete all records so that file
is clean for each report run.
HT
Dave McQueen
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
--
............................................
David A. McQueen
LICHEN Software
Barrie, ON, Canada
http://www.lichen-software.com/
705-720-9022
