>>yeah if the boss would allow me to do that I would.
If I create 2 remote views, then join them in 1 local view I can get that to work too but again doesn't want it done that way...ha<<<

My psychological answer:

Seems your boss "knows" what he doesn't want then let him/her tell you what he/she DOES want and how to do it.
PS he's willing to pay you for days to do it his/her way when you already have a solution?? Now that's logical!???