Need Help - Restaurant Database (1 Viewer)

[Hurly1223]

I'm creating a database for a restaurant using Microsoft access - they will use it on their tablet computers with each patron at the restaurant being given a tablet as they sit down and they can then order their food and drink from the tablet with the order​

directly transmitted to the chef and kitchen staff to prepare. Waiters will just beneeded to welcome patrons and serve the food once it is prepared.​

Successful scenario
• The Diner is seated
• The Waiter takes Tablet to Table
• The Customer enters order into the system/tablet
• The system alerts the Kitchen staff of the order
• The Kitchen staff prepare food
• The system alerts the Bar staff of the order
• The Bar staff prepare drinks
• The system alerts the Waiter that the drinks are ready
• The Waiter delivers drinks to the table
• The system alerts the waiter that the dish is ready
• The Waiter delivers the dish to the table
• The Diner orders a Desert
• The Customer enters the order into the system/tablet
• The system alerts the Kitchen staff of the order
• The Kitchen staff prepare the food
• The system alerts the waiter that the dish is ready
• The Waiter delivers the dish to the table
• The Management decide to issue a discount from the bill
• The Waiter uses the system/tablet to print out the bill
• The Diner offers payment
• The Waiter enters the payment details into the system/tablet
• The Management uses the system to view the statistics

Trouble:​

• I'm Having Trouble With The Relationships Between Tables / Also Not Sure Exactly If I Have The Right Fields In The Table​
• Having Trouble Making A Macro - Main Menu Has A Button For The Menus - Type In For Menu Type "Dinner, Lunch Etc." When I Click Button It Runs Query Parameter - Type In "Dinner" Then It Goes To "Dinner Form Menu" If I Type "Lunch" It Should Go To "Lunch Form Menu"
• I Have No Knowledge On How To Have A Button Next To An Item On The Menu That Is Add To Order - Then Finalize Order - So Then It Can Be Displayed On The Kitchen Interface With All The Orders To Be Cooked

I'm Struggling With This Because I Only Have Basic /Above Average Knowledge Of Microsoft Access

So If Anyone Could Help Me Out I Would Be Very Grateful - I have Done 80% Just These Things Are Stopping Me From Finishing

Picture Of The Relationships
i.imgur.com/LLZpWRA.png

 

[spikepl]

Is this an academic exercise?

 

[Hurly1223]

Is this an academic exercise?

Yes - I Just Need Some Help With It