Report from Table Yes/No

[cherkey]

Hello,


I've created a form that enters yes/no data (checkbox) for each product.

Table
Product | Fieldname1 | Fieldname2 | etc.
Thing yes/no yes/no

I'm stuck on creating a report that will display the Product name and the name of the field(s) if it is checked (yes).

Thoughts?

TIA
cherkey

[RuralGuy]

Do you consider your table normalized to at least 3nf? If not then Google the term and you will find tons of links that discuss this issue.

[cherkey]

Aaahhmmm...yeah, I guess I'll get back to you on that one....

*Looking into....*

cherkey

[RuralGuy]

It was not to put you off. It is just that problems such as you described arise often when the data is not normalized.

[cherkey]

OK, so perhaps this isn't very well normalized. So, I should separate the tables... one table for product names, one table that lists options that each product may or may not have (re: the yes/no).
Where do these get joined then? I'll have a data entry form which has a product name and some check boxes to select which option(s) the product has. How do I store the data for the products and their options? Do I essentially end up creating another table to store this data?
----I hope I'm explaining this clearly :-/ -----

cherkey

[RuralGuy]

Here's some good links to start reading in no particular order:
http://www.phlonx.com/resources/nf3/
http://support.microsoft.com/kb/283878
http://www.tonymarston.net/php-mysql...se-design.html