I have a parent table that has a reference to a child table containing just pictures. When I delete the parent record, I expect for the child record associated with the parent record to be deleted as well. any thoughts?
Things to know:
- The child table is the only is part of reference child table.
- There are 2 more ref to tables that are not is part of.
- The parent table is call "Real Estate" and the child table is call "Fotos".
- The child table has multiple physical columns for pictures. 5 in total.
- The parent table has many virtual columns.
- The child table only has one virtual column which is the automatic reference row list to the parent table.