Ozzie
I will look at this some more. I am having a hard time making this work in SQL Server (aside from the DDT). There is a SQL Server rule that is being violated and I am going to have to take a closer look. It will more than likely be Monday before I get back to you on this.
This is the message when I create the relationship on table 'Trade'.
When I create the relationship on table 'TradeDivision' I get the same message as above except it references invalid table 'TradeDivision'
Thanks