deletion on m2m tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022 04:41 AM
Hello
concerning: https://www.youtube.com/watch?v=yJttdDa-9xU there are 2 ways to create m2m table.
1. sys_m2m - New (I name it a "real m2m")
2. create a table with 2 references (I name it a "not real m2m")
Both ways can be used to add a related table to a form.
Concerning:
I can not use "Reference cascade rule" on "real m2m" tables.
I have done some tests.
u_m2m_users_incidents - a "real m2m" table"
u_m2m_users_incidents2 - a "not real m2m table"
both references user and incidents table.
If I delete a referenced user or referenced incident:
u_m2m_users_incidents - whole record is deleted
u_m2m_users_incidents2 - value is empty
Can I assume, that "real m2m" table will always delete the record or is this behavior adjustable?
Sincerely Detlef Biedermann
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 10:19 AM
Running into the same issue - @Detlef Biederma did you ever figure this out?