You mentioned product options as a possible add on. I am not in the food business but this is a must in likely 50 percent anyone that is using a system to order from and should be part of this lesson from the get go. For instance does the customer want cheese on their hamburger? if yes then it would cost them extra.
I agree, Garry. A large number of people would want this. That's why I'm almost definitely going to add it. I can picture having an additional popup that will appear if there are options available for a product. In the example you give, if you pick hamburger, another form would pop up listing all the options: cheese, lettuce, tomato, ketchup, etc. The SIMPLE solution at first would be to add these to the Notes field in the OrderDetailT and adjust the price accordingly. A better, long-term solution would be to also store these items in another related order table (OrderDetailOptionT, for example). I'll do both, eventually. Baby steps. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 14.
