binding secondary data source to populate fields in the same row

[KipHAPA]

Have an Infopath form connected to an access Database. Would like to bind a
dropdown Listbox on my form to a secondary data source table/ unique field
in access database . When the user selects that particular record, it will
populate other fields on my form in the same row from the database. Not sure
how to accomplish thru Infopath. If having to code, would like example in
vbscript. Familiar with Visual Basic, but in Microsft Script editor, don't
see dropdown of (objects ) created on my form or not sure how to attach
intrinsic functions to objects . Ex obj.text . Can you assist? Thanks

 

[jakewolfe]

Steps to take:
1. Drop Down box for the selection field
Let it get its value from the unique id (requires secondary data source)
2. Text boxes for the other field(s)
3. Set rules for the drop down box
a. condition === drop down box field is not blank.
b. Action: Set a field's value
Field: Field to be set
Value: Insert field to used for the field value
Apply filter to the field = secondary data
source is equal to the main data source (usings the unique id field that's
used to get the drop down box value)