I have 3 fields: Category, SubCat, and ProdID. First off I want sub cat to be a pull down menu but it changes depending on what category is selected. Then I want prodID to be an auto number that goes from 1000-9999. But it will depend on what category and subcategory are selected. How would I do this if it's even possible?