Adding Toppings (Updating Order)

[Mobe123]

Hi all, i would appreciate your professional help. i am create a restaurant POS. i have buttons on a form, where each buttons adds an item (Burger, Pizza...) into order table and displays it in a continues form. my question is how to add a topping to Pizza for example. let assume a customer order pizza i have the button that adds pizza but if the customer want a pizza mashrooms, onions how to update the selected record to including topping. of for example a burger with Ketchup as topping.

i want to update selected records or last record to include the toppings.

thank in advance

[NeoPa]

It's almost impossible to answer appropriately without knowing the basic structure of the tables you use in this process.

All I can really say is that the interface should allow you to select a pizza from your order list so that when an extra topping button is clicked the system knows which record to associate the additional topping with.

How does your database represent pizzas and their toppings?

[Mobe123]

Thank you for your quick respond attached please find the project i am working on so you have an idea, seeking your help

[NeoPa]

Mobe.

That really isn't how things work.

I appreciate you selecting my post as the Best Answer, but it isn't really the solution to your problem. It's merely a first step to try to encourage you to see where you need to address your energies and time. Thus I've reset that. Hopefully in time we'll get to the stage where another post can appropriately be selected. If not then no worries. The important thing is to help you to progress in your own understanding and increase your capabilities in Access.

Believe me though, when I say it will not be I that takes up the slack and does it for you. You will need to get ready to do some hard thinking and work on this project. That is a long way from meaning I'm not prepared to help - but that help will come as an adjunct to the progress you make. It will come as tips here and there, guidance along the road. Specific answers where appropriate as well as direction on how to change your approach to get where you want to be.

From you will be expected responsiveness to suggestions. Try out suggestions and feed back what you discover or how you progress (and even why they don't help in your circumstances if that's what you find). What will also be expected is that you explain your situation clearly using words. This is a forum site. Information is exchanged via explanations of problems and solutions - generally not via passing across a database for us to fix for you - not even for us to discover for you what should be explained in the thread. On the very rare occasions where any expert feels the need to see your project they will ask if that's acceptable to you. Offering your project is generally frowned upon as it usually comes with questions that need the database in order to be understood correctly. Never a good start.

We do appreciate this is hard for many but the rewards can be worth it. The discipline of expressing yourself clearly in words is truly invaluable anyway, quite apart from any help you get with Access.

You're new to the site so none of this is to be considered as a problem at this stage. Simply guidance on how things work here, and on most forum sites.

Let's take this back a step or two and see if we can work again with what you've already received.

PS. I've just seen and removed your later post. It wasn't there when I started this response.

[Mobe123]

Thanks for the keen words, all i am asking here is your expertise on how can i achieve to add a topping to a menu, i would never accept or expect someone to do the work for me. i would like suggestions/help ideas..... thanks a million in advanced and as you said i am new to this page and i must have click the best answer accidentally

[Mobe123]

When ever you have the chance can you have a look at the attached project and you will know exactly the help i am seeking.

[NeoPa]

Mobe123:
When ever you have the chance can you have a look at the attached project and you will know exactly the help i am seeking.

You seem to be missing the point here still.

Part of your role is to ask the question clearly. Expecting others to spend considerable amounts of time looking into your project to work out what the question should be is not. That's your responsibility. It's also down to you to respond to whatever it is you're told. I've already given as much as I can from the limited information available. You've done nothing with my response though. You only want me to look at your project and do what you should be doing.

That wouldn't help you. I know. I've been there. I suspect that your database design needs to be looked at and redone, but I can't advise on that yet, as I've had no response to my earlier advice. Certainly any advice on the form design would make no sense if the table design needs to be changed. It would quickly become irrelevant.

You seem to think I'm being deliberately awkward. I'm simply telling you that the hill you're facing needs to be climbed. I'm not looking to carry anyone up any hills, but I'll walk by you if you have the stomach to climb, and I'll point out any pot-holes as you get tired. Otherwise, well it's your choice of course.

[zmbd]

Mobe123 - have you normalized your database table structure?
Doing so will make this easier.

[Mobe123]

NeoPa, thanks for you answer, i think there is a bit of misunderstandin g, could be the language barrier. my first post was seeking your professional help/experience. as i previewsly said not in a million years would want any body to do work for me. when i mentioned to have a look at my project is for how ever is seeking to help to have a clear idea of what is my question. not to do the work for me.

thank you very much, i would try to type my question differently so it does not sound or seem that i want someone to do the work for me. all i am seeking is how can i edit my code so the selected record can be edited or updated(to include the topping).

Thanks once again

[Mobe123]

Hi zmbd, what do you mean by normalize database table

[zmbd]

Good Morning Mobe123
I've sent you a copy of resources to your Bytes.com>Inbox
Lots of different material that you should take a look at - some really basic to the more advanced.

As for normalization you should start with this:
home > topics > microsoft access / vba > insights > database normalization and table structures
(this link and other references to normalization are also in the document I've sent to your inbox)

As Neopa suggested, the root cause may very well be with your table design (aka: schema).

[NeoPa]

For clarity, I don't plan to proceed further with this thread. If the OP still can't appreciate why what they're doing is the wrong approach after I've explained why in detail twice already then I see no point in simply repeating myself.