filtering on items in a value list

[SSwettenham]

Problem:

Taking a subsummary of a value list only reports the first record in a multiple selected value list.

Example:

1. value list-

cat

dog

bird

2. field- petowner

Question:

How can you create a report that lists all petowners(2) with cats(1) etc. including listing the same petowner under a different value - dog(1)

The report should look like this:

Cat -

petowner1

petowner2

Dog -

petowner1

.

.

.

[LiveOak]

There are probably a lot of ways, but one is to use two related files: PetOwner and Pets. In the PetOwner file there is one records for each owner. In the pet file there is one record for each pet owned. You summary would be printed from the Pets file, sorted and subsummarized by Pet.

If you don't want to redo your data storage, you can create the second file and populate it with a script every time you want to run the report. -bd

[SSwettenham]

Thanks this worked very well.