I have a paradox datatabase with 3 dependent tables, parent , child, grandchild the database appears to have become locked up when the user tried to enter a record into the granchild table which had no match in the child table. The situation does not clear after rebooting. I have tried Reindexing and packing with no result I would greatly appreciate any help on this matter with respect to how to fix the problem in the first instance and secondly what i need to address to avoid it hapening again Thank for your time Ian Ian Fear 1427 Te Kopia rd RD 1 Rotorua New Zealand Phone 64 7 333 1548 Fax 64 7 333 2548 mob 025 742 772 [EMAIL PROTECTED] GMT +1200 http://mysite.xtra.co.nz/~IJFear/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz