473,323 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

puzzledom in a restaurant database

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


Nov 13 '05 #1
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

Nov 13 '05 #2
"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

Nov 13 '05 #3
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

Nov 13 '05 #4
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

Nov 13 '05 #5
"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
Nov 13 '05 #6
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


Nov 13 '05 #7
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



Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
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. ...
26
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...
15
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...
1
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...
0
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...
1
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...
1
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...
2
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....
9
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...
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.