>I have three tables namely 1. empmain 2. salary 3. recovery. The empid field is common for all three tables. I want to delete the record at once for all tables based on empid field. The empid field is Integer data type.
>
>How to delete the record?
If you always want to delete related records in "child tables" when you delete a record in the "parent table", you can set up referential integrity rules in the database. In that case, Visual FoxPro will create the corresponding triggers, in the database, to delete the related records automatically, any time you delete the parent record (even if you delete it manually, for example in a BROWSE window).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)