Unanswered: Data Integrity: Records unconsistent between tables
I have an old DOS FoxPro database that I am trying to port to access.
There is an inventory table that contains all the part numbers, and I made the part number the primary key, and I am trying to link it to a recieved table, which contains all the dates when additional quantities of parts were added.
Over time in the old database, people changed part numbers, and the recieved table is inconsistent, and has most part numbers that the inventory table does, but some that it doesn't.
How can I easily find which records are in the recieved table that aren't in the inventory table?
That took awhile and the query came up, but won't scroll down through the records or display how many records.
There are about 55,000 records in the RECV table and 18,000 in the INVN table.
This is on a 1GHz AMD with 512MB DDR RAM running Windows 2000 Server with Office XP Pro.