I want to create a form that has a drop-down box to chose a persons name.
Depending on which name is chosen, I would like the sheet to fill in a
contact name. Example: If they chose Joe Blow as the Producer, the contact
would be Sally.
But if they chose Jim Jones, the contact would be Kelly. What is the
easiest way to do this?