Delete subform lines automatically

tompynation
Member Posts: 398
How can you make the subform lines get automatically deleted ?
Do you have to program this in the OnDelete trigger of the main form its source table?
Or is this some property of the main form?
Do you have to program this in the OnDelete trigger of the main form its source table?
Or is this some property of the main form?
0
Answers
-
Have a look at table 36 Sales Header
Albert0 -
If you need the system to automatically delete records in related tables when a record is deleted in a certain table, you need to program this in the table's OnDelete trigger.
Albert's suggestion of looking at the Sales Header table is an excellent example. Open the table designer for this table, and look at the C/AL editor. Start at the top of the code and scroll down until you reach the OnDelete trigger. In here you will see everything that happens when a record in the Sales Header table is deleted by a user (i.e. on a form).0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions