Need help with Filtering Information

J

JD

Hi, I want to create a contact database. One of the field
will be Client Category and subcategory. Here is my list:

1. Gallery Service Providers:
Painters
Carpenters
Sign Designers & Painters
Floor - Sanding & Polishing
Carpet - Cleaners and Dyers
Insurance Companies
Security Companies - Alarm System


2. Gallery Professional Service Providers:
Accountants & Bookkeepers
Lawyers
Computer Designer - Website
Computer Technical Support
Computer Marketing and Public Relations


3. Advertising & Marketing:
Preview Magazine
Art Magazines
Newspapers - Georgia Straight
Printing Companies -

So, when user select main category then subcategory box
appears and user can see optins only available under that
category not all of them. Also, I need help with number
of tables I need? Other fields on the form will be the
name, address, phone number etc. Thanks in advance
 
Top