iRage Posted July 1, 2004 Share Posted July 1, 2004 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! Link to comment Share on other sites More sharing options...
RalphL Posted July 2, 2004 Share Posted July 2, 2004 Make a global field in proposal gCategory. Make a relationship to "ProductPriceList.FP5" gCategory = Category. Use this relationship for the value list. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7093 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now