Using a Conditional Value List or similar - Same table
I'm trying to work out how to use a Conditional Value List or similar on fields in the same table.
I'm using 1 layout to enter Product details into the one table.
I'm then using another layout to create an invoice.
As part of the invoice creation I'd liek to have th option to select a Product Category (dropdown) and have the Product Type(dropdown) which is on the same line contain only the Product Types that are members of that particular Product Category.
Product Category - "Shovel", Product Type "Round", "Square".
I've looked at a number of the example/demo's and FMP tutorials, but am still no closer. I can display all Categories and all Types in the appropriate dropdowns but cannot display the specific types for a specific category.