linking tables in access

[eddied95]

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 in table 2 are comparables.

Can I group the data? whats the best way to display this information?

Sorry for the poor description!

Thanks

[NeoPa]

It's hard to answer with so little information available. It's really even clear what you want.

Generally though, if you want to link records from one table to another with a one-to-many type link you would describe the link in the FROM clause of your SQL. For that you'd need fields that matched in some way though. I suspect you have such fields, but you haven't shared this info so I don't see I can take you any further at this time.