Auto Populate Fields based on Drop Down List Selection

[Leroy]

I want to Populate my fields from my SQL Data source depending on the drop
down selection.

example.

I have a facility table in SQL that has the following Fields

Facility Name, Street, City, State, Zip

I have a drop down list for selecting the Facility name.
Once I select the Facility Name I want the Street, city, state, zip to auto
populate from the SQL Table. I know about the Rules ability however I'm not
sure the syntax for the query in the formula. Can any one help?

 

[Anuma (GGK Tech)]

Hi,

Can you add following rule to Name Dropdown?

1. Open Name Dropdown Properties.
2. Select Rules button and Click on Add button.
3. Select “Add Action†button.
4. Select “Set a Fields value†from Action Dropdown.
5. In field text box select street field xpath from main data source (UI
field Xpath).
6. In values field, select fx button.
7. Select “Insert Field or Group†button.
8. In Data source dropdown, select “Facility (Secondary)†option. (This is
Db connection data source)
9. Select Street and click on “Filter†button.
10. Select Name (UI fu=ield) xpath in first dropdown.
11. Select “is equalt to†from second dropdown.
12. Select Name (Db field) xpath from third dropdown.
13. Click on ok until all windows are closed.

 

[cmckeef]

I need the exact same thing! I am able to populate the dropdown list - but I can't figure out how to have my selection populate the form field values below.

Any answer would be greatly appreciated!