Does Radicore allow orphaned children? [message #3374] |
Thu, 24 January 2013 17:56 |
David Lee
Messages: 44 Registered: June 2006
|
Member |
|
|
I require two tables, each with records that are related to zero or one records in the other table. My initial thought was a simple parent-child relationship, and use nullify on delete, allowing nulls in the foreign key and orphaned children. This does not work, and I suspect the way to do this is via a link table. I have also not found any Radicore relationships which use nullify on delete. So I have 2 questions:
1) Is the nullify on delete option usable in any situation? Any examples available?
2) Is there any simpler option than a link table for my requirement?
|
|
|