I'm new to the forum and am happy to have found a forum dedicated to databases.
I'm working on a little project for my construction business.
The problem is how do I store this information into a database efficiently. without reduntant information?
I plan to use this information to retrieve the following out of the table... How many inquiries did we get for "x" service last month? What services did the "xclient" inquiry about?
So far i have the basic table layout for the contact information and some other stuff but again i'm not sure to input that type of data.
you'll want one table for your clients, one table for your services, and then a third table, corresponding to each client's submitted checkboxes, which relate a client to a service -- one row for each checkbox that the client selected
this third table really needs only two columns, the clientid and the serviceid