Filtering Data

  • Thread starter Thread starter JoeW
  • Start date Start date
J

JoeW

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!
 
Back
Top