Creating a Infopath Form

[AJL]

I have a Access 2003 database that I am pulling from. I have a drop box that
would have registration numbers which is connected to the database and a text
box that would give the address and phone number of the facility. I want to
be able to use the registration number drop box to bring up the facility
information from the database. Is there a way of doing this? I am creating
this on a tablet PC for field inspections, and having the inspectors get the
address instead of writing it in will help them a lot. I have it to where
the drop down box gets the information from the database, but can't get the
text box to give the address.

Thanks,

AJ

 

[S.Y.M. Wong-A-Ton]

Did you already have a look at this solution:
http://enterprise-solutions.swits.net/infopath/dropdown-table-record-selection.htm

 

[AJL]

Thanks bro. It was at the end of the work day and should have researched it
more. That is exactly what I want to do.

AJ