I'm trying to streamline some forms for a daycare that involves what each kid eats each day. I would like to have a drop down that fills in other drop down lists, but is still able to be altered if needed.
For example, there are four infants who eat the same breakfast, lunch, and a late snack every day. Each infant has milk for breakfast and lunch, so I would like to click one drop down list and select "milk" and have the other drop down lists in the breakfast and lunch columns populate with "milk" as well - kind of like a master drop down. However, if a certain infant didn't have milk that morning, I would be able to change that certain drop down to "did not eat" without changing the others.
Then for the late snack column, I can have another drop down for "applesauce" and have all of the other drop downs fill in to "applesauce" for each infant in the late snack column. Again, if a certain infant did not eat during that time, I would be able to change that specific drop down without changing all the others.
It can get a bit tedious clicking 2 drop downs for breakfast items, 3 for lunch items, and 3 for late snack items per infant - at least 48 clicks per sheet for 6 infants. I'm sure there's a way to streamline this process.
I hope this makes sense. Please let me know if I need to clarify any more.
Thanks in advance for your help!
-Z-
Bookmarks