Search Challenge for Genealogy

[Clarkmcfly]

I encountered a problem recently for a genealogy database that I'm developing.

As an example, if I am to search for 1B's downlines (you can see on the illustration pic that I attached), I'm looking for a way to find all the "A" downlines strictly following the left connection (encircled) which should give a result like 1B->1BA->1BAA->1BAAA, etc.

I'm planning to use a script for this type of search, but I came to a dead-end when I tried to solve this logic. What would be your approach to this?

[Lee Smith]

See if this Thread helps.

Link