30 checkboxe possibilities narrow now

  • Thread starter Thread starter Carin Bunney
  • Start date Start date
C

Carin Bunney

I have 4 class categories (A,B,C,D) with 10 class
A1,A2,A3,A4 ...etc) in each category. There will be 1
checkbox selected from each category A,B,C or D.


I need to print out the customer name and each class
selecting in each category.
1. I could do a complicated if then statement on all 30
boxes and set ClassA="classAbox" id A10=Yes else...
and do this for each class. What would be the syntex?
2. or I could set a field callled ClassA= the class
selcted and then print a reoport from that. How would I do
this?

What is the easiest way to do this?
 
I have 4 class categories (A,B,C,D) with 10 class
A1,A2,A3,A4 ...etc) in each category. There will be 1
checkbox selected from each category A,B,C or D.


I need to print out the customer name and each class
selecting in each category.
1. I could do a complicated if then statement on all 30
boxes and set ClassA="classAbox" id A10=Yes else...
and do this for each class. What would be the syntex?
2. or I could set a field callled ClassA= the class
selcted and then print a reoport from that. How would I do
this?

What is the easiest way to do this?
Click to expand...

The easiest way is to restructure your tables so that they are
properly normalized. "Fields are expensive, records are cheap"!

You have a many to many relationship between Customers and Categories.
Rather than having a new *field* for each category, you should have
three tables: Customers, Categories, and CustomerCategories. The
latter table would contain one RECORD for each category in which a
customer is found.

John W. Vinson[MVP]
 
Back
Top