I've removed your post about a complex business scenario because it presents no idea about how you'd like us to help you.

Please repost with your ideas on the solutions and specify specifically where you need our assistance.