Thank you

Many thanks for sharing your knowledge and ideas and for your support. I'm going to mark this as solved now because I think the rest is upto me.
It seems that their is no perfect solution for me at the moment and I need to choose something that best meets my needs.
I will come back in a month or so and let you know what I did and the results in case it will be of value to anyone that stumbles on this thread in the future.
Thanks again.