Al-279884 (10/15/2009)

---

John Rowan (10/15/2009)

---

Yep, it makes sense. I'm not sure if that's how I'd design it, but it is what it is. My personal preference would be to...

John Rowan (10/15/2009)

---

That's fair. I think we need more info then from the OP as to how the addresses are currently being related to other entities.

meichner,

Care to handle...

John Rowan (10/15/2009)

---

Using the CustomerAddress table is the correct way to go if you truely have a many-to-many relationship between Customers and Addresses, but using the CustomerAddressID to 'link' that...

Al-279884 (10/15/2009)

---

If I am understanding it correctly you have a many-to-many relationship between customers and addresses. If that is the case you may be better off if you create a...

LovesSQLS (10/15/2009)

---

Your requirement sounds weird. On the first instance why do u want to modify the CustomerAddressID i.e Primary Key value and that too and Identity column. Whenever the...

Bradley Jacques (10/13/2009)

---

No need to apologize. I just want to get this right. I had actually setup the Sales Order table so that it was dependent on the CustomerAddresses...

Bradley Jacques (10/13/2009)

---

1. Should the field in the Sales Order table be dependent on the CustomerAddresses table or the CustomerAddressesXref table?

2. If it should be the CustomerAddressesXref table should I...

Can you explain why the dendency should be on the CustomerAddressesXref and not the CustomerAddresses table?

Thanks

Mark Marinovic (10/9/2009)

---

meichner (10/9/2009)

---

2. Here's a quick (and NOT thoroughly tested) way of obtaining the particular FK violation (this assumes an "FK_:" naming convention and is working with strings...

From reading the posts, it looks like I have two choices.

1) Before issuing the delete command, check each of the tables that reference the CustomerNumber to see if...

mtassin (10/8/2009)

---

Trust me when I say this.

Your users do not want to delete customers. Especially not the ones with sales information that depends on the customer info.

Later on somebody...

My SQL is kind of weak. So either I didn't really understand the previous posts (which I thank you for) or my question was confusing. Let me give...

Sorry to have bothered everyone. As it turns out this was not a SQL Server problem.

My apologies. I got a little nervous and jumped the gun with my post.

I want to thank everyone for the advice. It was clear and well thought out.

Thanks again.

Clive Strong (9/2/2009)

---

meichner (9/2/2009)

---

Clive Strong (9/1/2009)

---

Very true...If only my company would let me get my hands on EE!!

As for moving data from certain tables from production to development, you can...