Cannot enable cascading erase once the db is split?

[Sym]

I have a problem.....I have a form that has a subform. The parent forms data source is a query based on my "tblSalesOrder" table that collects the data on my customer like their name, Phone number and so on. The subforms data source is a query based on my "tblSalesOrderProducts" table, this collects the data on the products they order.

I set up a relationship between the tables so that if someone wants to delete the order it cascade deletes all the subform data attached to the order, this worked great until I split the database, now the cascading erase option is greyed out and I cant reselect it. is there a way around this?

thanks

 

[spikepl]

Did you check this in the backend DB?

Update:

And BTW, deleting is seldom done in a db, to avoid mistakes and also because you can run all kinds of useful statistics.

Normally an order would just get flagged, to remove it from normal daily run of things, not deleted (because deletions also would need to be secured against inadvertent deletions of valid orders)

 

[gemma-the-husky]

I agree with spike.

I hate losing hard-won data.

I hate cascading data updates and deletes. I never ever use them.