Acc97: Turning off Cascading Deletes via program code 
Author Message
 Acc97: Turning off Cascading Deletes via program code

I have two tables defined in Access97 that are linked in a one to many
relationship. The "many" table is an ODBC connected table, while the
"one" table is an Access97 table. When displaying the Relationship
information, the area where you can control the cascading options is
greyed out.

Currently, if I delete a record from the "one" table, the
corresponding "many" table record is deleted also.

I need to be able to delete a record from the "one" table without
automatically deleting the matching "many" record. My form is a basic
datasheet view of a field from the "one" table and a field from the
"many" table. The delete is done by selecting the row and pressing the
Delete key.

Thanks for any assistance.
Denny Pasternak
FDC - Teleservices
Omaha, NE

Tue, 15 Oct 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Acc97: Turing off cascading deletes via program code

2. turning off delete confirmation

3. Revision Balloons - Turning off via VBA?

4. Turning Off Confirmations from code

5. Numlock Turns off after code runs

6. How to turn off filter on Open Form Wizard code

7. how to turn off compiler when writing code?

8. Turn off auto complete with code

9. Turning monitor off from code

10. Acc97: Refreshing Form after Deleting Record in Code

11. Acc97 Execute Menu Add-In via Code ?

12. rst.delete, with cascade delete???


Powered by phpBB® Forum Software