Alexander, Adam, thank you for your suggestions.

I was hopping for a more transparent non-user interactive solution, which
means lots of work on the application(s), which points to using multi-tier
as the solution along with your suggested.

Once more thank you

daniel