I have a database frontend and backend in access 2000. The frontend uses tables from 3 other backend access databases. I am working on delete routines for certain records.
My question is how (where) the relationships for a setup like this should be handled. Should I be relying on cascade delete relations. If that is the case I am confused on how to define these between the databases.
My frontend has all the relations defined, but has grayed out boxes for the options (e.g. cascade delete, etc.).
Should this simply be handled with code - fine by me? Just want to make sure I am doing this the "right" way.
Thanks!!
Start Free Trial
