http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Multiple Parent Tables Sun, 12 Apr 2026 08:50:59 -700 Sat, 12 Nov 2011 17:09:21 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3090 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=3090&PID=12044#12044 Author: gregweb
Subject: 3090
Posted: 12-Nov-2011 at 5:09pm

Never mind, I got this working by changing the data structure a bit.

Greg]]> Sat, 12 Nov 2011 17:09:21 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3090&PID=12044#12044 http://www.ideablade.com/forum/forum_posts.asp?TID=3090&PID=12043#12043 Author: gregweb
Subject: 3090
Posted: 11-Nov-2011 at 8:06pm

I have two tables: Contacts and Addresses.

The Addresses table has a field called EntityId. There is a foreign key relation to Contacts. This works just fine, and the navigation properties work as expected between Contacts and Addresses.

Now I add a new table in called Companies. I add a second Foreign key relation to Addresses, so it can relate back to either a Contact or a company.

As soon as I do this, the navagation between Contacts and Addresses breaks. The error that is thrown is System.Data.SqlClient.SqlException: Invalid column name 'Company_Id'

It appears what is happening is that it is trying to populate the Addresses->Companies properties and of course fails as Companies isn't available just then.

What I am tring to achieve is that I can relate an address to either a Contact or a Company.

Greg
]]> Fri, 11 Nov 2011 20:06:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3090&PID=12043#12043