Rob
Posts: 13
|
| Posted: 05/07/2009, 6:54 PM |
|
Hi there
I am trying to build a online pizza ordering cart with asp using MDB.
with prebuilt pizza's no problem. but some customer's may want their own toppings on half or whole pizza and i have been trying to setup my database tables and fields according to that, after changing it for 100 times already i'm still not getting anyware. could anyone help me with it or if anyone can send me a quick 15 min example, i'll really appreciate it.
Thanks in advance for any help
_________________
I don't even know enough to know that i don't know. |
 |
 |
Waspman
Posts: 948
|
| Posted: 05/08/2009, 12:42 AM |
|
I've just built a multiple choice questionnaire builder which is sort of what you want. The questions (which could be what type of pizza) can be added and choices presented as check boxes. It's just 2 tables, one that stores all the questions and options and the other (a replica of the first) that captures the responses.
I present the questions and options on screen as an editable grid then hijack the delete function with a custom SQL script to insert the response into the log version (second table) of the main table. I add extra fields to the log version to capture the User id and date etc., but that could be the persons name and address etc.
T
_________________
http://www.waspmedia.co.uk |
|
|
|
Rob
Posts: 13
|
| Posted: 05/09/2009, 7:43 AM |
|
Thanks waspman
Let me try it out.
_________________
I don't even know enough to know that i don't know. |
|
|
|
Rob
Posts: 13
|
| Posted: 05/31/2009, 9:00 PM |
|
yeah that worked.
_________________
I don't even know enough to know that i don't know. |
|
|
|
|
