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
11 1021 NeoPa 32,556
Expert Mod 16PB
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?
Thank you for your quick respond attached please find the project i am working on so you have an idea, seeking your help
NeoPa 32,556
Expert Mod 16PB
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.
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
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 32,556
Expert Mod 16PB 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 5,501
Expert Mod 4TB
Mobe123 - have you normalized your database table structure?
Doing so will make this easier.
NeoPa, thanks for you answer, i think there is a bit of misunderstanding, 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
Hi zmbd, what do you mean by normalize database table
NeoPa 32,556
Expert Mod 16PB
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Scott |
last post by:
I have a view that contains the following SQL1 and it takes about 500ms
to run with Explain Plan EXP1. However, if I add an order by
clause(e.g. select * from view1 order by ID desc), it will then...
|
by: Alex Hemingway |
last post by:
I have a table Products consisting of the following fields :-
ProductID, ProductName, PriceLevel, UnitPrice
and a query which returns all products with a specific PriceLevel.
What I would like...
|
by: PRadyut |
last post by:
In this code i tried to add the elements in ascending order
but the output is only
0
1
2
the rest of the elements are not shown. the code...
|
by: Richard Rivera |
last post by:
I'm new to C# so bear with me.
I have a windows form with 2 text boxes: First Name and Last Name. I want
to create a method in my Data class that will handle both my New and Updated
data(first...
|
by: Karl Irvin |
last post by:
While adding data to a record set, I use something like
rst! = some variable
rst! = some variable
......
rst! = some variable
The rst! , rst! etc. are manually typed in and it gets...
|
by: Mark12345 |
last post by:
HI all I have downloaded Microsofts Order managment database.
I have spent hours trying to get the thing to come up with the totals of my new orders as a sub total so I can add VAT.
I have tried...
|
by: badvoc |
last post by:
Hi,
I have had some good fortune on this site so I am back and I must iterate I am a beginer.
I am having some problems getting to grips with the right technique to manage variables and...
|
by: omerbutt |
last post by:
AJAX PROB WITH MULTIPLE RECORDS
helo iam having problem in ma code will any body look out an help, i am trying t add sale record in the database and the checkthe quantity of the part slod and...
|
by: angus macgyver |
last post by:
hi,
i have a simple database that maintains customer info in one table and their orders in another.
when adding a new order for a customer i would like the customer name and id at the top of the...
|
by: clifford1988 |
last post by:
I finished an order form for a pizza company. It works but they want me to implement some math into it. I am unsure how to go about this, and am hoping I don't have to rewrite the entire form and...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |