July 1, 200421 yr 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!
July 2, 200421 yr Make a global field in proposal gCategory. Make a relationship to "ProductPriceList.FP5" gCategory = Category. Use this relationship for the value list.
Create an account or sign in to comment