Conditional Portal Value Lists

[iRage]

I will do my best to explain my problem.

Database "Proposal.FP5" houses a portal to database "pInvoice.FP5". "pInvoice.FP5 contains a relationship to "ProductPriceList.FP5".

The "ProductPriceList.FP5" database contains several fields including a category.

What I want to do is create a filter in the "Proposal.FP5" database that will only show items in the value list related to the filter.

ie: if filter = display ads, then every product who's category has display ads choosen will show up.

Does this make sense!

[RalphL]

Make a global field in proposal gCategory. Make a relationship to "ProductPriceList.FP5" gCategory = Category. Use this relationship for the value list.