Hello everybody,
I am making a db for recording ordered dishes for kitchen and the billing in
a restaurant. There is one problem. Rarely but it happens, two customers
sharing one table, for example Table No.1, order independently their own
food, then comes the puzzledom, the db can not manage to accept the two
different orders from the same table at this time.
I have been trying very hard, but so far can not find a solution. Can
someone help? Thanks in advance.
Paul 7 2393
Paul T. Rong wrote: Hello everybody,
I am making a db for recording ordered dishes for kitchen and the billing in a restaurant. There is one problem. Rarely but it happens, two customers sharing one table, for example Table No.1, order independently their own food, then comes the puzzledom, the db can not manage to accept the two different orders from the same table at this time.
Then you need to make a modification so it can accept two different orders.
You may need to structure your tables to
Table1#
Order1#
Item1
Item2
Order2#
Item1
Item2
Item3
etc
Either that or create a field to put in a sequence number.
Ex: Order1 Seq 1
Items ordered
Order1 Seq 2
Items ordered
Which is basically the same as the first example. You can have a party
of 4 and have 4 separate bills. So...you might have to modify the code
and structure slightly. I have been trying very hard,
In order to make life easy for yourself, when planning/building a
program try to get as much info you can prior to coding and then build
your code with extensibility into it. Practice makes perfect.
but so far can not find a solution.
There are as many solutions as you can dream up. I find sometimes it is
best to walk away from the computer, eat a candy bar, chat with someone,
get the mind off the problem. Oftentimes the solution will come when
you are not so focused you can't see the forest from the trees. I'm
sure there are many programmers that have woken up out of a dead sleep
with the solution to a problem.
Can someone help? Thanks in advance.
Paul
"Paul T. Rong" wrote I am making a db for recording ordered dishes for kitchen and the billing in a restaurant. There is one problem. Rarely but it happens, two customers sharing one table, for example Table No.1, order independently their own food, then comes the puzzledom, the db can not manage to accept the two different orders from the same table at this time.
Then you have a basic logic problem -- you need to go back to your design,
because you must be using the table's identity in some way that you
shouldn't. Your orders/billing will have to be by customer, not table. That
could be, however, "position at table" to identify customer/order. If you
have a party at the table where clearly one order/bill is needed, you can
arbitrarily select a "position".
Restuarant software is a highly competitive business; there are some
well-established, well-thought-of products. I know this from brief
participation in an Access software project for a national chain quite some
years ago. It's not, you might say, "as simple as it seems". If this is for
your own restaurant, you might want to do some looking around -- it is often
more economical to buy than build. If not, best of luck with your project.
Larry Linson
Hi Salad,
That is the best reply I've ever got. Thanks a million.
Paul
"Salad" <oi*@vinegar.com>
??????:qx****************@newsread1.news.pas.earth link.net... Paul T. Rong wrote:
Hello everybody,
I am making a db for recording ordered dishes for kitchen and the
billing in a restaurant. There is one problem. Rarely but it happens, two customers sharing one table, for example Table No.1, order independently their own food, then comes the puzzledom, the db can not manage to accept the two different orders from the same table at this time. Then you need to make a modification so it can accept two different
orders. You may need to structure your tables to Table1# Order1# Item1 Item2 Order2# Item1 Item2 Item3 etc
Either that or create a field to put in a sequence number. Ex: Order1 Seq 1 Items ordered Order1 Seq 2 Items ordered
Which is basically the same as the first example. You can have a party of 4 and have 4 separate bills. So...you might have to modify the code and structure slightly.
I have been trying very hard,
In order to make life easy for yourself, when planning/building a program try to get as much info you can prior to coding and then build your code with extensibility into it. Practice makes perfect.
but so far can not find a solution.
There are as many solutions as you can dream up. I find sometimes it is best to walk away from the computer, eat a candy bar, chat with someone, get the mind off the problem. Oftentimes the solution will come when you are not so focused you can't see the forest from the trees. I'm sure there are many programmers that have woken up out of a dead sleep with the solution to a problem.
Can someone help? Thanks in advance.
Paul
Hi Larry,
Thank you for you comment. Obviously my design has problems, logic or
whatever. I am working with it. Thanks for advise for the restaurant
software. The software is for a friend. So for him and me it is something
more friendship than a product. But I fully agree with you, that the
restaurant software is not simple at all and very often it is more
reasonable to buy than to build.
greetings from Bratislava, Slovakia
Paul
"Larry Linson" <bo*****@localhost.not> дÈëÏûÏ¢ÐÂÎÅ
:pJi9d.8509$Sl2.3894@trnddc09... "Paul T. Rong" wrote
> I am making a db for recording ordered > dishes for kitchen and the billing in > a restaurant. There is one problem. Rarely > but it happens, two customers sharing one > table, for example Table No.1, order > independently their own food, then comes > the puzzledom, the db can not manage to > accept the two different orders from the > same table at this time. Then you have a basic logic problem -- you need to go back to your design, because you must be using the table's identity in some way that you shouldn't. Your orders/billing will have to be by customer, not table.
That could be, however, "position at table" to identify customer/order. If you have a party at the table where clearly one order/bill is needed, you can arbitrarily select a "position".
Restuarant software is a highly competitive business; there are some well-established, well-thought-of products. I know this from brief participation in an Access software project for a national chain quite
some years ago. It's not, you might say, "as simple as it seems". If this is
for your own restaurant, you might want to do some looking around -- it is
often more economical to buy than build. If not, best of luck with your project.
Larry Linson
"Paul T. Rong" wrote Thank you for you comment. Obviously my design has problems, logic or whatever. I am working with it.
It was not my intent to just criticize your design, nor to criticize you,
but to try to point out the _part_ of the design you should examine in order
to correct the problem. Without knowing the design, I just couldn't be more
specific.
Thanks for advise for the restaurant software. The software is for a friend. So for him and me it is something more friendship than a product. But I fully agree with you, that the restaurant software is not simple at all and very often it is more reasonable to buy than to build.
No, restaurant software can be more than a little complex, particularly (as
is, I am sure, always the case) when you and the user look at what you have
and think "This would be so much more helpful if it only had .... <some
feature you are thinking about>... and it ought not to be hard to add that."
It might be worth your time to do some research on commercial restaurant
software to see what they and their customers consider to be the important
things to include, and to see how they have handled those things (from an
external or user interface point of view).
Larry Linson
Microsoft Access MVP
Paul T. Rong,
A restaurant is synonymous to a manufacturing plant in terms of the business
processes. An order comes in for a finished good, inventory is consumed to
produce the finished good, the finished good is delivered to the customer
and paid for. When tracking orders (I missed the beginning of this, so
forgive me if I am repeating what has been already said), you have to track
per seat rather than per table. Seat 1 at Table 1 ordered the steak
special, rare, sauce on the side, sub vegetable for example. You already
see the problem with tracking orders per table.
"Paul T. Rong" <et***@hotmail.com> wrote in message
news:ZV*********************@news.chello.at... Hi Salad,
That is the best reply I've ever got. Thanks a million.
Paul
"Salad" <oi*@vinegar.com> ??????:qx****************@newsread1.news.pas.earth link.net... Paul T. Rong wrote:
> Hello everybody, > > I am making a db for recording ordered dishes for kitchen and the billing in > a restaurant. There is one problem. Rarely but it happens, two > customers > sharing one table, for example Table No.1, order independently their > own > food, then comes the puzzledom, the db can not manage to accept the two > different orders from the same table at this time.
Then you need to make a modification so it can accept two different orders. You may need to structure your tables to Table1# Order1# Item1 Item2 Order2# Item1 Item2 Item3 etc
Either that or create a field to put in a sequence number. Ex: Order1 Seq 1 Items ordered Order1 Seq 2 Items ordered
Which is basically the same as the first example. You can have a party of 4 and have 4 separate bills. So...you might have to modify the code and structure slightly.
> > I have been trying very hard,
In order to make life easy for yourself, when planning/building a program try to get as much info you can prior to coding and then build your code with extensibility into it. Practice makes perfect.
but so far can not find a solution.
There are as many solutions as you can dream up. I find sometimes it is best to walk away from the computer, eat a candy bar, chat with someone, get the mind off the problem. Oftentimes the solution will come when you are not so focused you can't see the forest from the trees. I'm sure there are many programmers that have woken up out of a dead sleep with the solution to a problem.
Can > someone help? Thanks in advance. > > Paul
Alan Webb,
Thank you very much. It helped me to clear my mind.
Paul
"Alan Webb" <kn*****@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:e6********************@comcast.com... Paul T. Rong, A restaurant is synonymous to a manufacturing plant in terms of the
business processes. An order comes in for a finished good, inventory is consumed
to produce the finished good, the finished good is delivered to the customer and paid for. When tracking orders (I missed the beginning of this, so forgive me if I am repeating what has been already said), you have to
track per seat rather than per table. Seat 1 at Table 1 ordered the steak special, rare, sauce on the side, sub vegetable for example. You already see the problem with tracking orders per table.
"Paul T. Rong" <et***@hotmail.com> wrote in message news:ZV*********************@news.chello.at... Hi Salad,
That is the best reply I've ever got. Thanks a million.
Paul
"Salad" <oi*@vinegar.com> ??????:qx****************@newsread1.news.pas.earth link.net... Paul T. Rong wrote:
> Hello everybody, > > I am making a db for recording ordered dishes for kitchen and the billing in > a restaurant. There is one problem. Rarely but it happens, two > customers > sharing one table, for example Table No.1, order independently their > own > food, then comes the puzzledom, the db can not manage to accept the
two > different orders from the same table at this time.
Then you need to make a modification so it can accept two different orders. You may need to structure your tables to Table1# Order1# Item1 Item2 Order2# Item1 Item2 Item3 etc
Either that or create a field to put in a sequence number. Ex: Order1 Seq 1 Items ordered Order1 Seq 2 Items ordered
Which is basically the same as the first example. You can have a party of 4 and have 4 separate bills. So...you might have to modify the code and structure slightly.
> > I have been trying very hard,
In order to make life easy for yourself, when planning/building a program try to get as much info you can prior to coding and then build your code with extensibility into it. Practice makes perfect.
but so far can not find a solution.
There are as many solutions as you can dream up. I find sometimes it
is best to walk away from the computer, eat a candy bar, chat with
someone, get the mind off the problem. Oftentimes the solution will come when you are not so focused you can't see the forest from the trees. I'm sure there are many programmers that have woken up out of a dead sleep with the solution to a problem.
Can > someone help? Thanks in advance. > > Paul
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Fat Bloke |
last post by:
Not very good at this...
A friend has asked me to do his restaurant menu. This has several sections -
Starters, Main Courses, Vegetarian, etc, each section having different items
within it.
...
|
by: Brian |
last post by:
I have to markup a couple of restaurant menus. Two examples follow:
Clam Chowder Cup 3.25 / Bowl 6.95
Thick New England-style clam chowder with
clams, diced onion and celery, bacon, red
bell...
|
by: Paul T. RONG |
last post by:
Hello,
I am making a restaurant database (it is much more complicated than I
thought before!), now it comes to the last stage and I come across a
problem. I will explain it in detail. In a...
|
by: rumblepup |
last post by:
I thought this would be simple, but I cannot find anywhere a
downloadable or accessable national restaurant database. Don't even
need a big one, just the major chains. I had downloaded an access...
|
by: Kelly |
last post by:
Hi!
I wanted to invite you to visit my website, DietFacts.com. This project
started 10 years ago when my father was diagnosed with diabetes. He
really enjoys dining out with family and friends but...
|
by: hadi |
last post by:
Imagine a restaurant which we want to store information about. Two
types of people are related to it.
1) People who simply call and the foods are delivered to them.
2) People who actually come to...
|
by: hadi |
last post by:
Imagine a restaurant which we want to store information about. Two
types of people are related to it.
1) People who simply call and the food is delivered to them.
2) People who actually...
|
by: Brian Kendig |
last post by:
I'm trying to make a web page with a restaurant menu on it. Each line
on the menu is the name of a dish (left-justified) and that dish's
price (right-justified), with a dotted line between them....
|
by: drhowarddrfine |
last post by:
I don't want to use a db manager, like mysql, for such a small
database but I'm finding this trickier than I thought and hope someone
can provide some guidance.
I have a restaurant menu with...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |