Hey all.
I've been asked to make a database of customers to contact. Pretty general sort of stuff, except for one bit that my lack of experience stops me being able to do.
There is a field on the form called "outcome" which is a lookup box that lets users pick from a list of possible outcomes upon completing a call to that customer. What I need to do is make the form show some extra fields next to the outcome box depending what the user selects in the outcome box.
So if nothing is selected, I don't want to see the extra fields. However if a users selects "Appointment Made" I need a field to be shown where the user can enter the appointment date and time. There are a total of 7 possible outcomes, and of those 7, 4 have extra fields to be shown.
Can anyone help me out with a solution??
-Matt
I've been asked to make a database of customers to contact. Pretty general sort of stuff, except for one bit that my lack of experience stops me being able to do.
There is a field on the form called "outcome" which is a lookup box that lets users pick from a list of possible outcomes upon completing a call to that customer. What I need to do is make the form show some extra fields next to the outcome box depending what the user selects in the outcome box.
So if nothing is selected, I don't want to see the extra fields. However if a users selects "Appointment Made" I need a field to be shown where the user can enter the appointment date and time. There are a total of 7 possible outcomes, and of those 7, 4 have extra fields to be shown.
Can anyone help me out with a solution??
-Matt