We have an Access 2007 application that has a split form (built on Table-1).

We now need to add some type of facility that will allow our users to view
data from Table-2 (while working on the Split form based on Table-1).

They will then select one row from Table-2 which will contain 6 fields which
we need to plug into Table-1. We are still fairly new to Access and we are
not sure of the best way to accomplish this task.

Thank You,

Brad