Binding Help

[kgbo]

I have created multiple tables with data. From there, I developed a form that each table will be placed on the form and an individual can select an option from each table. From there, I would like for what the individual selects to be placed in its own column on a Master Report.



So, if one user opens the form and selects their different information, it would relay into one row with the information in each individual column?

How exactly is this done? I am a bit new to access.

[June7]

This is not proper design of relational database. Should not duplicate data.

Bind a form to the destination table, create combobox bound to field of destination table that references other table as RowSource. Select value from combox list to save the unique ID of the 'lookup' record into the field of destination table.