Conditional List Based on Employee Type
I have a simple table that has the employees name and there job description. Lets consider an order at a restuaraunt. I want to make a pop down list on the order that allows me to select the waiter assigned to that order. So i want it to make a drop down list htat only shows waiters, not bus boys, cooks, dish washers, or managers. How would i do this?