Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Synchronizing two tables
poppins
Member Posts: 647
Hi everyone,
I have two tables with the same primary key and many identical boolean fields(same id,same value).
I want that when I delete a record from table1, the boolean in table2 take all the value false.
Example:
record in table1: key=xxx, bool1=true bool2=true
record in table2: key=xxx, bool1=true bool2=true
If I delete the record in table1:
record in table2: key=xxx, bool1=false bool2=false
Is it possible?
I have two tables with the same primary key and many identical boolean fields(same id,same value).
I want that when I delete a record from table1, the boolean in table2 take all the value false.
Example:
record in table1: key=xxx, bool1=true bool2=true
record in table2: key=xxx, bool1=true bool2=true
If I delete the record in table1:
record in table2: key=xxx, bool1=false bool2=false
Is it possible?
0
Comments
Why not? Just before the record in table1 being deleted (so in the OnDelete trigger of table1) make sure to update the related record in table2.
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community