I am trying to set up a hierarchical relationship between 2 tables in a datset. I have a table tblParent and a table tblChildren but not all Children have Parents.
When I try to display, I get the error: This constraint cannot be enabled as not all values have corresponding parent values
Is it possible to have 'orphans' and if so how to I set up this relationship so it will allow children with no parents ?
Can anyone help ?