Wow, that worked - thanks.  And, I was able to 'order by familyname, facilityID' and it seem to worked.

Thanks Jeff, when I changed the line, my results were

3456 1 Smith Tom Jane

3456 1 Smith Jane null

1234 2 Jones Kim null

It's kinda frustrating since originally the table design (not mine) had the parent info in the same record as the family...