I have two SP Lists - Category and Sub-category. Category has one field - CAT_NAME. Sub-category has two fields - SUB_NAME, CAT_NAME.
I am trying to create a new list which will have three fields - TITLE, CAT_NAME, SUB_NAME.
I want the CAT_NAME to be drop-down and lookup from sp list Category. I want SUB_NAME to be drop-down from SUB_NAME and lookup from sp list Sub-Cateogry but have the drop-down values filter based on CAT_NAME selection in form.
For example the categories may be Hardware & Software. The sub-categories would be Fix, Upgrade with Hardware as CAT_NAME and Question, Install with Software as CAT_NAME.
I have tried every conceivable manner of Filter on the XPath field filter with no luck.
Can someone help?