Awesome! That worked! So I didn't even need a join...

Thanks a lot man,

Joey

But if ran the select without the insert which table would I select from? All 4 Site, Tier, Ip_Address & Lan? They are all populated except the Router...