I have a Food Menu ordering database. There is a daily menu and in that menu one can order any amount of food in that particular menu.
I have these two tables where I want to create a form to enter the quantity.
MenuItems (Table)
MenuItemsID (PK)
FoodID (FK from Food Table)
MenuDayID (FK)
Order (Table)
OrderID (PK)
MenuItemsID
CutomerID (At the moment there are only 10 Customers, FK to Customer Table)
DateOrdered
Quantity
In the form I should have displayed the MenuItems for the day (Which is already entered) and a Column for the Quanity.
I'm having a hard time trying to figure out how to have the full menu with the quantity field in the same record of the subform.
The form should display the MenuItems for the day and a text box for each item where the user just enters the quanity requested.
As a subdatasheet it works. But doesn't look very good to a user, besides it will show the other customers' orders.
For each MenuItems record there are many Order records.
I have these two tables where I want to create a form to enter the quantity.
MenuItems (Table)
MenuItemsID (PK)
FoodID (FK from Food Table)
MenuDayID (FK)
Order (Table)
OrderID (PK)
MenuItemsID
CutomerID (At the moment there are only 10 Customers, FK to Customer Table)
DateOrdered
Quantity
In the form I should have displayed the MenuItems for the day (Which is already entered) and a Column for the Quanity.
I'm having a hard time trying to figure out how to have the full menu with the quantity field in the same record of the subform.
The form should display the MenuItems for the day and a text box for each item where the user just enters the quanity requested.
As a subdatasheet it works. But doesn't look very good to a user, besides it will show the other customers' orders.
For each MenuItems record there are many Order records.
