Make a [Menus] table where each record has a date, and maybe another field to show the menu type (i.e. “breakfast”, “dinner”, etc. if you want multiple menus per day). Add a formula field called {Status} using a formula like: IF({Date Field} < TODAY(), "Old", IF({Date Field} > TODAY(), "Future", "Current")).
Make a [Menu Items] table where each record is an item which can be ordered.
Make a [Schedule] table where each record links to a {Menu Item} and a {Meal}, with another record for {Max Count} to store how many of that item can be ordered. Add a lookup field called {Meal Status} pointing at the [Meals] table’s {Status} field. Make a filtered view called “Available” where {Meal Status} = “Current”.
Make a [Orders] table where each record is a user’s order for a particular menu item from a particular meal/menu. Add a field linking to the [Scheduler] field which only allows selections from the “Available” view (so people can only order from current menus). Add a checkbox field to mark when the order has been delivered.
Go back to the [Schedule] table and add a count field which counts how many linked {Order} records there are. Add a formula field called {Left Available} which subtracts the count of order records from the {Max Count} field. Adjust the “Available” view to also only include records where {Left Available} > 0.
