I'm getting close to this working, but not quite.  I select the name for the Employee Name, but nothing appears in the Supervisor Name field.  I've attached a sample of what I'm doing.  There are more names involved, but I'm figuring that if I can get a few names to work, I can copy for the others. ...

How do I do the hardcoding? It's not that much to update and sounds simpler, or at least more self-contained in the long run.

Ok, so this is sounding like a lot of work.  I could put the data in a DB, that's not an issue.  Is it something that even after we'd get it set, someone could access if they're away from the office not directly logged into the computer, just doing something web-based?  There's no way to manage the ...

The info is in an Excel file right now and since it's a relatively small amount of info it's in two unlinked dropdown boxes, in LC.  Is there a preferred place to have it or any way to just link the two fields?

How do I set up a field to automatically populate based on the enter in a previous field?  Example: Choose an employee name -- Automatically display manager name.  Thanks!

In a form I created, I would like to use the e-mail button, but I have variable e-mails that the form could go to based on how a certain field is populated?  Is there a way to set e-mail button to submit based on how a certain field is populated?  Thanks!