If you have a key in main that points to middle and then another table also points to middle. And you want to put the key from the other table into main. This would not be normalized. Since the third table refers to middle and main also does this would be a redundant relation. You should go through middle to find out the association of main to the third table. I hope this helps.
Stephen Kuhn
Prism Network, Inc.
System Developer
At last we can reveal ourselves to the Jedi.
At last we will have revenge.
-Darth Maul