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, 200718 yr by Guest

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

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

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!!!