Radicore Forum: How To » LIST3 linked from LIST1

Home » RADICORE » How To » LIST3 linked from LIST1 (LIST3: As I scroll through the parents, or children, the grandchild does not change)

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

Re: LIST3 linked from LIST1 [message #4836 is a reply to message #4835]

Sun, 12 July 2015 05:28

AJM
Messages: 2362
Registered: April 2006
Location: Surrey, UK

Senior Member

What you have there is a circular relationship, but having a foreign key linking to a primary key with a different name is something that occurs more than once in the MENU database. For example:

parent (MNU_TASK)
-----------------
task_id VARCHAR(80)

child (MNU_MENU)
----------------
menu_id VARCHAR(80) REFERENCES parent(task_id)
task_id_jnr VARCHAR(80) REFERENCES parent(task_id)

A relationship is a relationship, even if it is circular, so you handle it as any other relationship.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		LIST3 linked from LIST1 By: rafs on Wed, 08 July 2015 19:08
		Re: LIST3 linked from LIST1 By: AJM on Thu, 09 July 2015 05:44
		Re: LIST3 linked from LIST1 By: rafs on Thu, 09 July 2015 16:17
		Re: LIST3 linked from LIST1 By: AJM on Fri, 10 July 2015 04:43
		Re: LIST3 linked from LIST1 By: rafs on Thu, 09 July 2015 16:55
		Re: LIST3 linked from LIST1 By: AJM on Fri, 10 July 2015 04:52
		Re: LIST3 linked from LIST1 By: rafs on Thu, 09 July 2015 18:10
		Re: LIST3 linked from LIST1 By: rafs on Thu, 09 July 2015 19:12
		Re: LIST3 linked from LIST1 By: AJM on Fri, 10 July 2015 05:01
		Re: LIST3 linked from LIST1 By: AJM on Fri, 10 July 2015 04:55
		Re: LIST3 linked from LIST1 By: rafs on Sat, 11 July 2015 18:19
		Re: LIST3 linked from LIST1 By: AJM on Sun, 12 July 2015 05:28

Previous Topic:	How to bulk import my users into Radicore?
Next Topic:	How to change the screen title of a list1 task

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 02 03:37:47 EDT 2024

Total time taken to generate the page: 0.01123 seconds