Radicore Forum: How To » Does Radicore allow orphaned children?

Home » RADICORE » How To » Does Radicore allow orphaned children? (Relationship with nullify on delete)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

[Message index]

		Does Radicore allow orphaned children? By: David Lee on Thu, 24 January 2013 17:56
		Re: Does Radicore allow orphaned children? By: AJM on Fri, 25 January 2013 02:05
		Re: Does Radicore allow orphaned children? By: David Lee on Fri, 25 January 2013 13:10

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 08 12:22:16 EDT 2025

Total time taken to generate the page: 0.09854 seconds