Delete record problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Form A and form B both have a related field
How to keep the record in form B even tthe related record in form A was deleted
Thanks.
 
As long as you DO NOT have 'cascading deletes' turned on in the relationship
between the two tables, then deleting records in one table will not affect
records in the other. But you will have to provide a way of accessing the
orphaned records in the other table.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
that's correct as long as you have *not* enforced referential integrity in
the relationship. if you have, then you can delete a record from the child
table without affecting the parent table - but you can't delete a record
from the parent table when related records are present in the child table.
 
Back
Top