Here is what I am trying to do...
It is just a simple application to track food that is in multiple kitchens so that leftover items can be used before spoilage. For example, one of the chefs planned on using 18 lbs of asparagus in his soup. His projections changed, so he ended up using only 10 lbs. He has 8 lbs, and does not have asparagus soup on his menu for the week. However in another of our kitchens, a different chef has grilled asparagus planned on a menu. The product could be used over there, and not go to waste. Multiply this by multiple ingredients in multiple locations. Each chef inventories their own kitchen, and currently, they are just emailing one another. Instead, I am hoping to make a handy-dandy little application that shows the location, amount and type of food that a chef is hoping to get used elsewhere. Each chef enters the items into a form, and right now, they have to enter the kitchen (it is just a dropdown, so not a big deal) over and over again. A simpler/better solution would be to add it once per time they sit down to enter the information. The way I currently have it set up, I was hoping for an easy way to just default the Location (kitchen) to the value that was last entered into the table.
