I have a form that is looking up a person's contact information based on their department name.  When the department is chosen the associated person's name with their phone and email are supposed to auto-fill.  It works correctly if there are multiple people associated with a department and the user picks a name from a drop-down.  If there is only one person associated with the department the name populates but not the phone and address.  It's like the form doesn't know to use the name as a look-up if the field auto-populates.

SQL table looks like this:

Department                      ContactName      ContactPhone            ContactEmail

Public Works                     Joe Smith            555-555-5555            person@email.com

Public Works -Roads         Nancy Jones        222-222-2222            person2@email.com

Public Works -Roads         Mel Brown           444-444-4444            person3@email.com

Form Look-up Rule:

Thanks for your help.  I can provide the form is needed.

Sandy