populate from dropdown to textbox

[abc]

i have a the following:

Main Connection includes the fields for gender (male or female) and
name (user's names).

Secondary Connection includes the fields for id, gender, and name.

I have a dropdown list that is binded to the 'name' in Main Connection.
The data is being pulled from the secondary connection, 'name'.

Then, I have a textbox which is read only and is binded to the 'gender'
in Main Connection.

I need the textbox to auto-populate with 'gender' when the user selects
a name in the dropdown list.

please help!

 

[Scott Roberts [MSFT]]

You can do this using a combination of default data, formulas, and filters
(available in SP1).

Do the following:

1. Open the properties dialog for the TextBox by double-clicking in the
control in the view.
2. Click on the Fx button next to the value field
3. Click the Insert a Field or Group button
4. Choose the gender field from the secondary data source
5. Click the filter button
6. Click add
7. From the left-most dropdown choose the name field from the secondary data
source
8. Leave the middle dropdown as "is equal to"
9. Open the right-most dropdown and choose "Select a field or group"
10. Choose the name field from the main data source
11. Close all the dialogs

Now, when you preview or open the form and choose a name from the dropdown
the gender will display in the textbox.

I hope this helps.

- Scott