By my count, you asked 16 hours ago. That's about 6PM my time (Central US) so when most of the primary users of this site went home to spend time with their loved ones. Since then you've had about 15 people look at it, you're asking about the intermingling of two databases (specialized knowledge) and you're asking a site for experts.
But primarily, I (a moderator, one who sees more than a fair share of bad questions) can't really tell what you're asking. You give a lot of side-story, but you're not really asking a firm concrete question.
Possibly you could use some formatting to help you with that, but I imagine a complete re-write is in order. I would also encourage you to read through: http://tinyurl.com/so-hints before getting upset that you didn't have an army of monkeys flinging poo and bananas at your question.*
* meaning: Stack Overflow is not necessarily the best site for you to ask this on, you can be almost sure that you'll get a good answer there, but you really want (and need) expert answers on this topic (schema management).