Delete record problem.

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.
 
A

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
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Access Project - Almost There Just Need Some Help... 2
Access Automatically Send a notification email once a record is added 0
Access not enforcing referential integrity!!! 11
How do I open a specific Access form record by simply clicking on a field in another form record fie 3
Related records depend on other related records 2
Record insert/delete anomaly 0
Separate Form 0
Child table/subform 5

Top