Database Design Problem 1

[T111]

I have customers that can use up to 5 products. I have 5 tick boxes and each product being used by the customer will have a tick box alongside it. I need to print a report with the products that they use and not to display any products they don’t use e.g. Customer A uses Product X and Product Y so the report should only display Product X and Y on the report. Customer B uses Product Y and Product Z so the report should only display the products currently active (ticked). How can access decide at runtime to hide/display the products being used by reading the tick boxes in the customer table and displaying the appropriate products. I don’t want to create over 20 reports covering all possibilities. Any solutions appreciated.

 

[SQLSister]

Just base the report on a query that uses a where clause to filter the records based onthe values stored for each product.

I would suggest though that you design seems somwhat limited. I would store this data in a related table rather than as five fields in the main table. Then if the number of products changes inteh future, you don't have to change table structure and program code.

Questions about posting. See faq183-874