this referential integrity gives following errors

[trkl]

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. earlier i asked question and i found solution.thx for that. Regards

 

[JHB]

Oh no - I don't want to install anything to download you database, zip it and post it here.

 

[Pat Hartman]

Try running an unmatched query. Use the wizard to build it. This query should identify the unmatched records.