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 - Just These Things Are Stopping Me From Finishing

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