multiple dynamic value lists

[bhag]

I have created a dynamic value list via a relationship. I would like to have another dynamic value list that is a subcategory of the first value list. The problem is that the second list would be based on multiple criteria. I need to create several fields with pop up lists that will eventually be narrowed down to one record.

Make sense?

I am using FM6

I appreciate any help.

[-Queue-]

For version 6, create a child calculation field that concatenates the criteria, separated by underscores or spaces, and a parent calculation field which concatenates the subcategory with globals (or whatever you're using to filter criteria), using the same separator, and base your relationship on these fields.

[bhag]

Thanks Queue that worked great!