MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: Setting up foreign keys to match MS Access relationships
Posted by: Ronald Weng
Date: October 31, 2005 04:05AM

Hi murray

the problem could be this

Table A is dependent on Table B

You've imported data for table A but not B so when you attempt to create a Foreign Key in Table A that depends on data in Table B you will get that error.

Second problem could be the data contains duplicates so you cannot create the foreign key constraint.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Setting up foreign keys to match MS Access relationships
7443
Murray Muspratt-Rouse
October 08, 2005 05:40AM
Re: Setting up foreign keys to match MS Access relationships
2978
Jonathan Shaltz
October 12, 2005 02:04PM
Re: Setting up foreign keys to match MS Access relationships
2663
Ronald Weng
October 31, 2005 04:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.