30 checkboxe possibilities narrow now

[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?

 

[John Vinson]

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?

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]