I'm trying to delete a record from a table, but it doesn't work: "This Room can not be deleted because: A House references it".
To describe it in a simple way: I have a table 'houses' and a table 'rooms'. 'rooms' has a foreign key to 'houses' with "ON DELETE NO ACTION". I'm trying do delete a room, not a house. So the message above...i can't understand it. It should be possible to delete the room without the TRUE-flag of delete (), shouldn't it? The house doesn't reference the room, only the room references the house.
As far as I can see, the relationship is discovered as a one-to-one. But in my opinion, this is not really a one-to-one, because a house can have more than one room.
I'm not sure if i don't understand how it works or if it is a bug. Can someone explain it to me?
Thank you very much!