I am using InfoPath to look up Employee information from a SQL Server
DB in a Search View/Tab of a form.  The issue is now that only one of
the employees will be the correct person for the form.  I would like
the users to be able to search from a set of all employees then select
the employee they would like the form use information about.  So for
now i'm thinking that a button with text along the line "Select This
Employee" within the repeating section would copy the employee data to
a static non-repeating set of fields.  Employee information is only a
sub-section of data in the form, but it does need to be looked up
dynamically.

Any help would be appreciated?