I have a product category drop down list that pulls from a specific value list.
After I choose that specific value I need for the Product field to only show the values specific to that product category ( Like below)
Can someone tell me how to do that?
You need to create a relationship (based on Product Category) between the file you are working in and the file that contains the product and product Category fields.
Then in the value list that you use for the drop down, tick "Include only related values starting from" and specify file, i.e. the file you are working in.
This file contains an example. If you notice, value lists are created for models, but the lists include only those assigned to projects. In the drawings table you can see how only the products are shown when the relevant project is selected in the presentation table.
I will try that and see if it makes things easier.
This is is part off a rolling 18 month forecasting spreadsheet that my boss made, (He's a engineer so he things differently ;-) )I'm trying to simplify things by making it in FMP.
If things work out on this Im hoping to have the whole workbook in in FMP and then help elevate some of our head aches.
Retrieving data ...