Foreign Key to Same Table

Create a custom view for the same table and link the main table with this custom view as master-details.

Thanks. This works.

Hello,

This solution works if there is only one dependency or a recursion level of 1, but if it has more levels, I have not been able to make it work.

For example, if we have directories that depend on directories and that in turn have more directories, that is, it has 2 or more levels of dependence, that relationship of the different levels does not find that it is seen on a screen.

Cheers,
fernando

I'm also thinking about that how to solve this in PHPRunner.
Still didn't come to this part in the project that I'm working on, but when the time comes I will try with some of the solutions from one article (answers) from stackoverflow. Here is the link if someone else would find some of the ansers helpfull and if you have the time to try it out. Maybe if you find the solution that would work in PHPRunner could share with us?

Here is this article (answers) from Stackoverflow:
https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query

Hello,

In the last example that I have published "I have solved" the problem of the addresses deepening one by one and facilitating "a trace of crumbs", so that it can be uploaded to any level of directory that you have already passed.

https://fhumanes.com/blog/sistema-de-archivo-de-documentos-electronicos-edas2/

But I understand that this can be a solution, but for me it is not the best.

Cheers,
fernando