Referential Integrity Problem
Posted on 2004-08-18
I have two tables, tblOrders and tblOrderDetails on which referential integrity is enforced. I have an orders form which an order detail subform. When the user chooses an order type, the code saves the record and then pulls up an additional form asking for more information based on the order type. This code has been used for 6 months without incident. Yesterday, I started getting a run-time error message saying that a record couldn't be located in tblOrders. When I hit debug, the problem appeared to be on the code which saved the record. On the theory that the file had been corrupted, I did a compact/repair on both the tables file and the front-end file. No luck. I created a new file for the tables, no luck. I have checked tblOrders and the required record is definitely in the table. I have no idea what to try next. Any ideas on your end?