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

Access 2007 Relationship between an ODBC linked table and a local table

P: 1
Hi all,

I have an ODBC linked table with a 3-field combo key. I am trying to link to a local table using the relationships window. I can drag the first line fine, but when I try to drag the second key field, the error message "A relationship already exists. Do you want to edit the existing relationship? To create a new relationship, click No." displays. I have never seen this when linking non-ODBC tables. Please help.
Dec 20 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,709
This is nothing to do with ODBC. It is general linking.

When you drag the first field across you are creating a link. A compound key uses a single link with multiple fields, so you need to edit the link to add further fields (which the interface supports).
Dec 21 '11 #2

Post your reply

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