conditional value lists with a show all option

[drg]

Here is my scenario I have 2 files one containing names of subjects and the other of diffferent tasks the subjects perform. Every time a subject is entered a set of tasks that the subject performed is assigned to them. Because there are a large number of tasks I want to be able to display just various categories of tasks. This I was able to accomplish using techniques for dynamic value lists described in this forum. Each task record in the task file also has a field for category. Then in the subject file the user makes a choice of category to display. Through a relationship I can then show just task names where the categories match.

The problem is I also want a choice to show all task names. Thus the user could choose to just show a single category, or to show all. Is this possible?

Thanks,

darren

[Fenton]

Basically you only have one relationship to filter with. So you have to do something so that it can match either the category, or all categories.

Relationships can match on any line, if a multi-line value. So, what you can use is a "1" for the "All" line; or you can use the word "All" if you want. I'm a minimalist.

First, create a calculation field in the target file.

Category & "

[drg]

Thanks. Worked like a charm.

Darren