Add Row with Add Child Row and Activate()

I found a scenario in which there is a bug with Activate() when adding a row to one table and then associating that new row in an AddRow() for another.

The expected behavior is that Activate() will open the row it’s tied to, which I wanted to target to the parent table row, but it actually just opens the child table row every time.

The solution is to use a Relations canvas control, which I’ve also documented here:

I’ve validated the issue and proposed solution with @Eric_Koleda

This issue also occurs with the OpenRow() formula and is consistent whether using a chain of AddRow() formulas or WithName().