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

[Cathy Hosek]

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.

[NeoPa]

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).