InfoPath Dev

This has probably been answered in some form on this forum, but I have a specific method in mind.

 I have a dropdown box that gets its data from a sharepoint list. For example it pulls a list of bus routes, and the user selects one. Below that are a series of text boxes for information such as Clock In, Clock Out, Depart, etc. All of this data is stored in the same sharepoint list as the data for the dropdown box. What I would like to do is set the default values of the text boxes to match the data recorded for the route selected from the dropdown box. I think there is a way I can manipulate a default value formula for each text box. How would I go about constructing this formula?

 Thanks.

Set a default value on each box and set it to the corresponding node from the secondary data connection, but filter each according to the selection in the dropdown.  The statement is like this:

"ClockIn(SPList) where BusRoute(SPList) is equal to BusRoute(IPForm)"

- You click the fx button next to the default value field for the data element in your form.

- You click Insert field or group

- You change the data source to your SP data connection

- You drill down to the corresponding node (i.e. ClockIn) that matches the current data element

- You single-click that field and then click Filter

- In the Filter, you set the BusRoute node of the secondary data connection as being equal to the BusRoute field on your form that is bound to the dropdown

Do this for each, and when you select a bus route, all the other fields will auto-populate with the proper info.