creating this referential integrity give following error.

[yture]

in below database http://www.4shared.com/file/XbC2kv5A/Supplier.html in the product table,most of the records were added by importing Excell 2010 workbook whose link is below http://www.4shared.com/file/Yz3MEF1_/Goods.html when trying to enforce referential integrity between above two tables,i get the following error message. Microsoft Access can't create the relationship and enforce referential integrity. Data in the Table 'Product' violates Referential integrity Rules.For example,there may be records Relating to an employee in the related table but no record for the employee in the primary table. Edit the data so that records in the primary table exist for all related records.if you want to create the relationship without following the rules of referential integrity, . clear the enforce referential integrity Enforce checkbox. but i checked all records and they are related.plz tell someone where lies the error. its ok if you dont answwer.you are just my friends. Regards

[stmoong]

It means that the field you are trying to create the referential integrity has values that are not found in the master table. You need to create the records with the missing field values in the master table.

[yture]

by master table do you mean primary table.

[stmoong]

By master table, I mean the table that contains the master data that you refer to in your other table.