MySQL Forums
Forum List  »  Microsoft Access

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Setting up foreign keys to match MS Access relationships
2433
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.