I have a SQL Data Source with three columns for simplicity (Organization_Name, Organization_ID, Organization_Parent_ID).
I am receiving the following error, "This constraint cannot be enabled as not all values have corresponding parent values." This makes sense as some of the Organization_Parent_ID values are null. How can I circumvent this error message, showing all of the parent organizations with their children underneath?
It should look something like this:
I see in the Object Data Source example in this link
that there are multiple root level items as well.