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.
Having a hard time trying to figure out how to have the full menu for the MenuDay and have the quantity field for each line by Customer in the form.
As a subdatasheet it works. But doesn't look very good to a user.
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.
Having a hard time trying to figure out how to have the full menu for the MenuDay and have the quantity field for each line by Customer in the form.
As a subdatasheet it works. But doesn't look very good to a user.
For each MenuItems record there are many Order records.