Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Does Radicore allow orphaned children? (Relationship with nullify on delete)
Does Radicore allow orphaned children? [message #3374] Thu, 24 January 2013 17:56 Go to previous message
David Lee is currently offline  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?

 
Read Message
Read Message
Read Message
Previous Topic: Missing Multi2 column + debug tips + modify dbObject by task
Next Topic: Parameters to batch functions / timeout
Goto Forum:
  


Current Time: Thu Nov 28 02:13:15 EST 2024

Total time taken to generate the page: 0.01059 seconds