need multiple columns of data from an from external data source

[Kevin in PA]

I am creating a form where I have a drop down list box. The list is connected
to a data source on Sharepoint 2007. I want the form to take additional
information from that list and pre-populate another text box, but I can't
figure out how to create the rule. Can anyone help?

For example:
I have the name, address, city and state in a list, and they are all
separate columns. I want to create a rule where when the name is selected in
the form, the address, city and state get prepoluated into another box in the
form. Can it be done?

 

[Swathi]

Hi

Put the rule on the dropdown using the following steps.
1. Click Add action button in Rule window.
2. Select 'Set a fields value' in first drop down.
3. Select the 'address'(main data source) field in Field box and select the
'address'(secondary source) then clcik on 'filter data'.
4. put the condition that Name(seconday source) equals to Name(main source).

Use same rule for city and state.

Hope this helps you.