Troubleshooting referential integrity
Posted on 2008-06-17
Table A Table B
pkFieldOne Text 1>>>M fkFieldOne Text
pkFieldTwo Test 1>>>M fkFiledTwo Text
9000 records 7000 records
Not all records need to reside in Table B just all 7000 records need to relate to Table A
Access 2000/2003 recognizes the 1 to many relatiionship but it won't allow the setting of RI
I have ran two unmatching fields One where pkFieldOne = fkFieldOne and the other where pkFieldTwo = fkFieldTwo fix the problems then tried to set RI and it still will not set. I think I have unmatching groupings of fieldOnes and fieldTwos
I found this problem by the ability of adding data into TableB without any error messages. This messes things up.
How do I run one unmatching field query where it pkFieldOne = fkFieldOne AND pkFieldTwo = fkFieldTwo?