<div>
Hi - Thanks for your response. Those were generic examples. The actual tables are Project &gt;&nbsp;Task &gt;&nbsp;Task_Team. Screenshot attached. And the error is below:<br />
<br />
'Task' table saved successfully<br />
'Task_Team' table<br />
- Unable to create relationship 'FK_Task_Team_Task'. &nbsp;<br />
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint &quot;FK_Task_Team_Task&quot;. The conflict occurred in database &quot;WSAProject&quot;, table &quot;dbo.Task&quot;, column 'Task_ID'.<br />
<br />
<br />
Thanks,<br />
Steve
</div>


<div>
That error is confusing me, since I removed the foreign key constraint from the Task_Team table, yet I'm getting that error on the key I removed??? And I can't find anywhere how to add multiple child tables to the same parent foreign key id. Thanks.
</div>


<div>
In SSMS right click on the table and script out the CREATE TABLE statement, then post into this question. <br />
It will include any existing constraints.
</div>


<div>
CREATE TABLE [dbo].[Task_Team](<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Task_Team_ID] [int] IDENTITY(1,1) NOT NULL,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Task_ID] [int] NULL,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Person_ID] [int] NULL,<br />
&nbsp;CONSTRAINT [PK_Task_Team] PRIMARY KEY CLUSTERED <br />
(<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Task_Team_ID] ASC<br />
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br />
) ON [PRIMARY]<br />
<br />
GO
</div>


<div>
Ah - I found some orphaned records, that 'splained it! Thanks.
</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm trying to create an ER diagram in SQL server, and am not understanding how to tie multiple tables to a parent table, such as customer_address and customer_order to the customer table. If I associate the customer_id as a foreign key in address and order, I get a conflict error. So how do you associate multiple one-to-many relationships all referencing customer_id in the diagram?<br />
<br />
Thanks,<br />
Steve
</div>
</div>


Hello,

I'm trying to create an ER diagram in SQL server, and am not understanding how to tie multiple tables to a parent table, such as customer_address and customer_order to the customer table. If I associate the customer_id as a foreign key in address and order, I get a conflict error. So how do you associate multiple one-to-many relationships all referencing customer_id in the diagram?

Thanks,
Steve

SQL Server database diagram

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.