Delete record problem.

[Jay]

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.

 

[Adrian Jansen]

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

 

[tina]

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.