That is the issue I am having when I go to create the 2nd relationship from the org table (parent) to enroll (child) on orgid. It doesn't work, it returns all rows from the org table. When I got to relate it to the orgid, it gives me the following message. "A table in multiple relationships can have one child order" When I do this with simple SQL outside of the form, everything joins correctly, so something in the Data Environment is not working the way I think it should.
=
Note:
The 1st relationship is between people (parent) to enroll (child) on personid.