By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

linking tables in access

P: 1
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
Feb 22 '10 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
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.
Feb 23 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.