Hey, I'm trying to create a type of filter to use in a database i'm currently creating. Basically, there are two categories, Products, and Sub Products. I believe I'm close, as I can get it to work somewhat, but it's not doing quite what I need it to. I have a front end form, on which I have several fields presented for viewing. When editing data, I have a predetermined set of Products that a user could select from, for example, Services, Medical Services etc. What I want is, when a user selects a more broad group such as Medical Services, a different combo box would then be populated with a selection of Medical Services SubGroup. I want to use predetermined lists like this to keep conformity within the data. The way I'm currently attempting to achieve this is I have two different tables, my main one with customer information, and then a second, Products table which has two columns, Products and SubProducts. I then went through and specified Products column Medical Services, SubProducts Dentist, so Dentist would be a subproduct of Medical Services etc. I then have a sql query like this: SELECT SubProduct FROM tblProduct WHERE Product=(text box on the form) Is this a viable solution to my problem? Or is there something I'm not seeing, or don't know. Thanks for any help anyone can offer!