Hello,
I have a form that has SharePoint Contacts data at the backend.
What I am trying to do is this:
When a name is selected from the DocOwner pull-down (the list is from the
SharePoint FullName list), I would like the DocOwnerEmail and DocOwnerPhone
pull downs to be automatically populated with that DocOwner's information. or
example:
I have John Smith, jsmith@ms.com, 444-555-5555 listed as a contact in SP.
When I choose "John Smith" from the DocOwner pull-down, I want the
"jsmith@ms.com" and "444-555-5555" to be automatically populated in the
appropriate fields.
I am guessing I can do this as a rule, but with 20 users that may change
over time, I'd like to find a general way to populate the appropriate fields
by just choosing the name of the contact.
Any help would be greatly appreciated.
Thanks!
Greg Collins [InfoPath MVP] - 25 May 2005 23:07 GMT
Rules or code will work. You need to filter the contact information, based on the selected user, to get the correct information to populate the fields with.

Signature
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com
Hello,
I have a form that has SharePoint Contacts data at the backend.
What I am trying to do is this:
When a name is selected from the DocOwner pull-down (the list is from the
SharePoint FullName list), I would like the DocOwnerEmail and DocOwnerPhone
pull downs to be automatically populated with that DocOwner's information. or
example:
I have John Smith, jsmith@ms.com, 444-555-5555 listed as a contact in SP.
When I choose "John Smith" from the DocOwner pull-down, I want the
"jsmith@ms.com" and "444-555-5555" to be automatically populated in the
appropriate fields.
I am guessing I can do this as a rule, but with 20 users that may change
over time, I'd like to find a general way to populate the appropriate fields
by just choosing the name of the contact.
Any help would be greatly appreciated.
Thanks!