Generic Invoice Inquiry showing the parent and child accounts

I’m not really sure of how this is going to play out, but I am trying to generate a Generic Inquiry invoice whereby the parent is the bill_to_name with the child customer no and ship_to_name associated with the child account. At one point I did manage to get both but in most case, the child account was duplicated multiple times including the invoice number and total sales. I did try it by using one instance of customer as a parent, and a right join on another instance of customer as a child, and it worked until I startted putting the bill_to_city, bill_to_state and the child ship_to_city, ship_to_state. It really got convoluted. If anyone has anything that they’ve done in the past along these lines, please share. I’ve tried using some of the Out-of-the-box GI’s and modify them but so far no joy.