>>Nadya,
>>
>>Just set delete to cascade for the relation. Open the database, select Edit Referential Integrity from the Database menu, click on the Rules for Deleting tab, scroll to the Regions and TownRegions relation and set to cascade.
>
>Brien,
>
>I'm trying it, but it gives me an error message: "Database should be cleaned up". But this option is disable in the Database menu. What should I do? I already tried to validate database.
Nadya,
Open the database exclusively. Close & reopen fox, issue SET EXCLUSIVE ON, open the database and the menu option should be available.
Brien R. Givens
Brampwood Systems