Grouping Drop Down Values

Grouping Drop Down Values

Hi All,

I'm trying to get a  Parts Selection sub form working in my Repair ticket form.

I have 4 fields in my sub form:

  1. Model
  2. Parts Catagory (Base Plastics, MotherBoard, Screen PLastics, Screen etc..)
  3. Parts Description (this would list say Screen Fascia, Palm Rest, Screen Lid etc..)
  4. Part No.
What I want to be able to do is Choose a category, which then lists the descriptions under that category but only category once. 

So for example, I choose "Screen Plastics" as my category and I want 2 options, "Lid" and "Screen Bezel".  However as I have about 5 different part numbers for Lid plastics, based on different laptop models currently my "Part Description" will list "Lid" 5 entries in my list.



How do I get the list to show only one instance of he part description based on the category selected and then I get the 5 part numbers in the "Part No" list ?

I'm currently using the "Set Filter" properties within the field itself, for example for the "Part Description" field:
Part_Catagory == input.Part_Catagory

Kind Regards

MattP