S
Sally
I have a Access2000 db split. Extensive forms have
already been created based on queries. I have now gone
back to back-end to set referential integrity to prevent
users from deleting data. Users can't delete a record in
the table that other tables are using. This is also true
for a new form I created based only on one table. But
the form I created prior to setting ref integrity using
multiple tables in a query does not support the
referential integrity and allows users to delete records,
thus creating orphaned data.
How can this be resolved? Thank you!
already been created based on queries. I have now gone
back to back-end to set referential integrity to prevent
users from deleting data. Users can't delete a record in
the table that other tables are using. This is also true
for a new form I created based only on one table. But
the form I created prior to setting ref integrity using
multiple tables in a query does not support the
referential integrity and allows users to delete records,
thus creating orphaned data.
How can this be resolved? Thank you!