Hi -

I have 2 tables in access currently - all rows have been a unique identifier value assigned.

I want to assign a number of rows from one table to one row in the other table

e.g. in table 1, there is information on a real estate property (1 property per row). each property has a number of comparable sales of properties which I would like to link to a specific property in table 1. All the properties...