I have a hospital food menu ordering database. I made one table which houses the menu and another which is the order table. The way I made the form is that when a particular menu date is viewed the Order table is filled with the Menu Table, so the user can see the menu AND enter the quantity they want. The problem I have is that once they view the Order it has already been populated and if at the last minute the menu changes it will NOT populate the changes.
The Menu table entries cannot be modified only let a checkbox titled ACTIVE, where the kitchen marks if the food is available or not and also the ability to add new menu items.
I made a routine that checks each record line in the Order Table and changes, adds or deletes records if necessary, but only changed the MenuID (FK to Menu Table) from the Order Table. I am having a hard time trying to get the quantity fields.
I was thinking of scraping that idea and uploading all the records from the Order table to a temporary table before doing any modifications, but how would I compare tables to repopulate the Order Table to add or remove entries based on the Active checkbox from the Menu Table and accurately get the original quantity?
The Menu table entries cannot be modified only let a checkbox titled ACTIVE, where the kitchen marks if the food is available or not and also the ability to add new menu items.
I made a routine that checks each record line in the Order Table and changes, adds or deletes records if necessary, but only changed the MenuID (FK to Menu Table) from the Order Table. I am having a hard time trying to get the quantity fields.
I was thinking of scraping that idea and uploading all the records from the Order table to a temporary table before doing any modifications, but how would I compare tables to repopulate the Order Table to add or remove entries based on the Active checkbox from the Menu Table and accurately get the original quantity?
