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 ...