Can I have 2 different sets of child and grandchild tables for the same parent table?

[CorneliusH]

Hi

 I want my app to let me chose between 2 methods of workflow depending on a choice I make in one of the fields with a Y/N question. I set up 2 child tables, and made both of them part of the original table.

Both of the tables have their field "Related Table's" in the parent table, so I made one visible if Yes, the other if No. But only the "no" (the default option) series is working. If I select "Y", instead of running to the B1 and B2 tables, it redirects to home view. 

Am I expecting to much? Am I omitting something?

[CorneliusH · Accepted solution]

The answer is Yes it is possible, I got it resolved by myself. 

[Steve]

Well done!

[MMMiles]

You didn't specify this, but if the structure of the child tables is identical/similar, you could use a slice to filter what child records are visible - then your logic will carry over for other views/functions with minimal extra work.

Regarding multiple children, the relationship is one-way: the parent table does not hold any references to the child tables. The number of child tables is not a property of the parent table.

[CorneliusH]

In this case, it is 2 very different things, but so far so good. It seems to be running smoothly.