merge two database into one

[Paul]

I have database A (computer invoc information) and database B (user
information). I would like to create a form as we assign a computer to a user
we can create or merge the information into a single database and only thing
the deployment tech needs to add is the tracking asset tag.

We been using access database to see if infopath can accomplish this task.
As for now nothing we have tried with Infopath was able to pull info from
both database and put it into one.

 

[S.Y.M. Wong-A-Ton]

Create a new database (manually) to save the computer and user information in
and bind your form to it. Then add 2 secondary data sources to your form that
will pull the information from database A and B.

 

[Paul]

Sorry to be such a idiot, but could you walk me through the steps. What do
you mean manually create a new database? also i have tried the secondary
database but it always gave me the full list when I ran the query not the
just the one I was looking for.

 

[S.Y.M. Wong-A-Ton]

Sorry, my wording was a bit confusing.

With manually I meant in MS Access. After you create the database containing
a table with fields for computer and user in MS Access, you can use "New from
Data Connection" in InfoPath to bind your form to the database. Drag the
group node for the table from the dataFields section to your form to create a
repeating table or section. Add 2 data connections to your form through
"Tools > Data Connections". These data connections should be bound to the
other 2 databases where you have the information for the computer and user.
Change fields in the repeating table/section to be drop-down list boxes and
bind these drop-down list boxes to the 2 data connections you created. By
using the "Filter Data" option on a drop-down list box when you are binding
it, you can filter the values in the listbox to correspond to the selected
value in the form. Do not forget to use current() in your filters to identify
the current row in the repeating table/section.