P
Papote via AccessMonster.com
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 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?