Filtered Join- Need a Nudge

[rdean13]

Hello, I have utilized some files posted in this and the portal forum to get close to what I need, but am having trouble with a final piece...

I am using a join table to show items that a customer has selected. On the customers record, I also need to be able to filter those items by a category (portal). I am not quite sure how to set up this relationship. I feel like the attached file is pretty close, but I just can't seem to get over this final hump.

Thanks for any help & advice,

Robb

Filtered_Join.fp7.zip

Edited February 28, 2007 by Guest

[matthew tucker]

I am trying to achieve a similar thing. Did you manage to solve your filtered join table in the end?

[The Shadow]

Here's a version modified to display the names in the category properly. Another version of the Items table was needed to get the names to display properly (Items 2, since no cycles can appear in the graph).

Hope this helps.

Filtered_Join.zip

[rdean13]

Matthew- no I had not resolved this question, but Shadow got it...

Shadow- thank you for helping out, I was unable to see this last step for some reason.

Many thanks!!!