deleting record - Microsoft Access / VBA

Johan

I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?
txs
Johan

Nov 12 '05 #1

Subscribe Post Reply

2470

John Mishefske

Johan wrote:

I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?

Set the relationship to be "cascade delete". Deleting the one-side record
will cause related records in table2 to be deleted.

Tools, Relationships, find the relationship line between table1 and table2
and double-click on it and click the Cascade Delete checkbox.

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #2

Allen Browne

Open the Relationships window (Tools menu).
Double-click the line joining the 2 tables.
Check the box for Cascading Delete.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Johan" <jo***********@pandora.be> wrote in message
news:6L*******************@phobos.telenet-ops.be...

I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?

Nov 12 '05 #3

Similar topics

Deleting a record from a VIEW

by: XmlAdoNewbie | last post by:

Hi All, I am using Microsoft SQL Enterprise Manager version 8.0 and have created a view from a combination of 4 different tables. I would like to be able to go into sql and open the view and...

Microsoft SQL Server

Deleting records in main form and subform

by: Mark | last post by:

This question refers to a main form with a continuous form subform. After an error occurs after entering several records in the subform, how can I delete all the data in the main form and all the...

Microsoft Access / VBA

Deleting Records

by: Nathan Bloom | last post by:

Hi, I have a data entry form (access 2000) that also allows the user to add, update, and delete records from the form. The Delete action is carried out in an event procedure and has the...

Microsoft Access / VBA

Problems making or deleting records through a form control button

by: uv | last post by:

Hi! I'm having problems submitting a new record through the form. I'm working with the wizard and I've added a control button to my form for entering entering a new record but for some reason it...

Microsoft Access / VBA

Deleting records in table makes hinders data entry form

by: KC | last post by:

Hello, I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB. I have tweaked this DB to work for our small co. It has worked pretty well up until I made the mistake of deleting...

Microsoft Access / VBA

Deleting filtered records not working properly.

by: deekay | last post by:

I'm using Access 2000 working in DAO at the moment and am having trouble deleting a record from a form that has been filtered. So I'm filtering a form and then when the user selects the record...

Microsoft Access / VBA

deleting records

by: DP | last post by:

hi, i've got a form, with a subform in it. i've got a delete button in the subform. the code i;ve got is; Private Sub cmdDeleteRecord_Click() msg = "Are you sure you want to delete this...

Microsoft Access / VBA

Safely deleting a db record with php

by: MaXX | last post by:

Hi, I hope I'm not OT. I have the following issue: I want to delete a record from my db with a php script. Let's say I'm auth'd and I want to delete the record id 440. With a simple form (get...

PHP

Deleting Forms with VBA

by: sphinney | last post by:

I'm not exactly sure how to start this post. My question is pretty simple, but it will take a little bit of context before I can state it. (And thanks in advance for taking the time to read this!) ...

Microsoft Access / VBA

problem in deleting data

by: Kyosuke18 | last post by:

Hi everyone, I have a problem in deleting a data that is connected on the database.. I tried this code but it shows me an error: Run-time error '-2147217900(80040e14)': Syntax error in string in...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General