How to link a second field to what was filled in in the first

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

basharnas@yahoo.com - 12 Jul 2005 21:22 GMT

Hi, I'm new in Infopath (and also in SQL). I have a simple Access
database and can create a drop-down to select a Customer in a new
Infopath document.
Now I want to select a Contactperson which is in the same database in
Access. I want to show this Contactperson automatically when the
Customer is chosen.

Any help is greatly appreciated.

Thanks very much.

Reply to this Message

Renee in Juneau - 13 Jul 2005 02:49 GMT

Check out the first two webcasts here:
http://msdn.microsoft.com/office/understanding/infopath/multimedia/default.aspx

I can't remember if it was Scott or Josh, but one of them demonstrates
the technique using an XML source. Just extrapolate it to your db
source and you'll be fine.

>Hi, I'm new in Infopath (and also in SQL). I have a simple Access
>database and can create a drop-down to select a Customer in a new
[quoted text clipped - 6 lines]
>
>Thanks very much.

Reply to this Message

basharnas@yahoo.com - 14 Jul 2005 22:20 GMT

Thanks for the response. I looked through most webcasts, but one
question still remains. I succeeded in selecting the correct address
with the correct company selected. But do I always have to do this
through Drop down list boxes? Is there another way to display lookup
values without the drop down box?

Thanks again.

Reply to this Message