Skipi Posted February 9, 2009 Share Posted February 9, 2009 Hi, I'm looking to build a product selector database. If I choose a size, i want it to only show the product in that size. (i have this part working). When I select the product, I want to then only show the sub items related to that product, and again for the next level down. I've tried various methods to get it to work, but I'm stumped! I've attached a sample of what I'm trying to do. Thanks for your help in advance, Skip Test_Product_Cat.fp7.zip Link to comment Share on other sites More sharing options...
Brian C Posted February 9, 2009 Share Posted February 9, 2009 Looking at your example, it is difficult to see what you are trying to accomplish workflow wise... You have relationships and seem to be using them in some manner for related value lists to filter out data... Perhaps if you provided a little more detail as to what you would like your solution to do step by step, it would help us to help you. Link to comment Share on other sites More sharing options...
Skipi Posted February 10, 2009 Author Share Posted February 10, 2009 Hi, I found this attachment from Topic#181645, it has a conditional value list that selects state/province by country. ie USA -> Texas, California etc. This part I can figure out, what I want to do is add the next level. So I get a conditional value list that will only show cities in that state/province. Ie from country list, select USA -> this shows list of Texas, California, Maine, then select California -> this will only show San Fran, LA in the value list. I hope this is a bit more clear. Many thanks, Skip CONDBASIC_Copy.fp7.zip Link to comment Share on other sites More sharing options...
Skipi Posted February 10, 2009 Author Share Posted February 10, 2009 (edited) Hi everyone, I found what I was looking for. I just didn't know the correct terminology of search under. Here's the link http://www.fmforums.com/forum/showtopic.php?tid/197738/ Thanks for your help, Skip Edited February 10, 2009 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5554 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