Howdy! This is a 2-part question:
There's this form that is created to collect a variety of information (4 pages):
This information is then passed on to another form that will display and calculate an estimate on a web page.
is this a new site: (check box) Yes (check box) No
if no, current URL:
if yes, desired URL:
what kind of pages would you like: (check box) Home (check box) Contact (check box) Sitemap (check box) Feedback and so on
I'm guessing I'm going to have a many-many relationship database, but I don't know how to store the multiple-checked values (the ones that the customer has clicked) in the customer's data table.
Some ideas would be appreciated!
Table: rsPages (optional text they want to add)
Table: rsOptions (this table would have the id and list of optional values)
Field: option (i.e., contact, home, SEO, etc.)
Table: rsEstimate (this would be the info. collected and retrieved (in combination with the other tables) to display on the estimate page)
Thank you for your time!