AnsweredAssumed Answered

Recursive Custom Function

Question asked by ChrisJohnston on Nov 18, 2013
Latest reply on Jan 17, 2014 by philmodjunk

Title

Recursive Custom Function

Post

     In my solution that is based on this type of relationship (pic) I have a custom function called Infobase(). What it does is let me deduce the parent of a particular Primary Key. I use it to do things like link Information Topics back to found sets.

http://pctechtv.com/show/cus.png

     So I am imagining that I keep feeding the result of Infobase() back into itself that I can come up with the parent of all parents in a particular topic. I was looking into to recursion in Custom Function and saw some info that said a Custom Function cannot iterate but it can recursively call itself. Assuming that is true I would think that this can be done with my function Infobase(). Eventually the “empty” of the result could insure we are at the highest parent. In my attempt to create a recursive Custom Function I must be doing something wrong?

Outcomes