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

[basharnas]

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.

 

[Renee in Juneau]

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.

 

[basharnas]

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.