Help: Drop down menu values connected to three other variables
I am trying to track a restaurant's performance over a period of 7 days for three services, i.e breakfast, lunch and dinner.
- There is a drop down menu to select the service from three possible values - breakfast, lunch, dinner
- Numeric variable field # 1 for number of customers - to be manually populated daily
- Numeric variable field # 2 for number of servers - to be manually populated daily
- Numeric variable field # 3 for number of total revenues per service - to be manually populated daily
As this will be tracked over seven days, there will be 21 (3 sets for 3 services per day for seven day) sets of records.
Question: what do I need to do to connect each individual data set for a specific day and specific service. E.g. on Monday, for breakfast, we had 25 customers, 3 servers and $500 of revenues.
Thanks for your suggestions!