By adam.skinner on

I have a CCK node type that is a collection of other nodes. I have a field in the CCK called "node1" and another called "node7". I'd like to create a view where I can have a filter that shows all of the CCK nodes that contain node x in the fields node1 to node7.

A normal SQL query might be:

select 
from CCK
where node.nid in(CCK.node1,CCK.node2,CCK.node3...)

What I'm trying to avoid is them having to use a set of filters:
filter1 = node1 ONE OF nid
or
filter2 = node2 ONE OF nid

Rather, I'd like filter1 = node1 or node2 or node3... ONE OF nid.

Dig? How can I do this?