fill fields automatically from a Drop down list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Goldin - 02 Mar 2007 04:33 GMT

I have a shrepoint list of customers and want to select the customer by name
from a dropdown list and have it fill the rest of the fields automatically.
ie: address, phone, city , zip etc.

Reply to this Message

S.Y.M. Wong-A-Ton - 04 Mar 2007 08:22 GMT

This article should help you out:
http://enterprise-solutions.swits.net/infopath2003/article.php?t=autofill-fields
-dropdown-selection-secondary-data-source&c=infopath2003

It uses a database table to populate a drop-down, but you can use your
SharePoint list instead of a database table. The principles are the same.
---
S.Y.M. Wong-A-Ton

> I have a shrepoint list of customers and want to select the customer by name
> from a dropdown list and have it fill the rest of the fields automatically.
> ie: address, phone, city , zip etc.

Reply to this Message

Larry Goldin - 05 Mar 2007 19:32 GMT

Thank you so much this was a big help!!

> This article should help you out:
> http://enterprise-solutions.swits.net/infopath2003/article.php?t=autofill-fields
-dropdown-selection-secondary-data-source&c=infopath2003
[quoted text clipped - 7 lines]
> > from a dropdown list and have it fill the rest of the fields automatically.
> > ie: address, phone, city , zip etc.

Reply to this Message

S.Y.M. Wong-A-Ton - 07 Mar 2007 05:58 GMT

You're welcome!
---
S.Y.M. Wong-A-Ton

> Thank you so much this was a big help!!
>
[quoted text clipped - 9 lines]
> > > from a dropdown list and have it fill the rest of the fields automatically.
> > > ie: address, phone, city , zip etc.

Reply to this Message