Home » RADICORE » How To » LIST3 linked from LIST1 (LIST3: As I scroll through the parents, or children, the grandchild does not change)
Re: LIST3 linked from LIST1 [message #4836 is a reply to message #4835] |
Sun, 12 July 2015 05:28  |
AJM
Messages: 2382 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.
|
|
|
 |
|
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
|
Goto Forum:
Current Time: Fri Jul 11 06:28:50 EDT 2025
Total time taken to generate the page: 0.19141 seconds
|