Mark, thank you for the response and thank you for the work and sharing it here.
I understood about multiple db's (there are other parts of the scenario I'm not up to speed on tho). I need a solution that is transparent to users.
There is no way four different users with 7 devicies will be able to do this here. It is simply too much to ask a casual user to navigate thru...and I simply do not have the time and energy to create and maintain the seven instances needed to initiate the process....and there are at least three computers that maintain 3-to all seven devices...ugh...you can imagine how the authorization process in itunes alone is a nightmare.
I will hopefully be able to make the time to try your process with my device and see how it goes. I will probably have more questions...lol.
Thanks you again for the interest and help in figuring something out.
*edit- wasn't able to download file...limit was reached.

