Thanks for the reply Scott.

The 2 fields are reside in the Deals table for 2 different reasons. Please excuse the terminology, Im no expert but the DealFamily allows a "is-a"...

Checked it out, not quite there.

I'll try to explain a little more.

A deal always has one dealtypeId.

A deal can be one of 3 variants - an Offer, a Product or...

Hi, thanks for the reply, I'm in the process of checking it out.

The reason for the persisted column is this;

Table1:...

I guess, the initial posting does look rather complicated.

Here's a simpler explanation of what I'm trying to achieve - hopfully.

Table 1: Deals (PK DealId)

DealId int

DealTypeId int

Table 2: DealEvents (PK...

Sean Lange (5/29/2012)

---

There are lots of people around that can and will help. However what you posted is not enough information to even fully understand your question let alone be...

Thanks for your advice guys.

I am coding a website for my own business. At the moment I have to be a jack of all trades, and I'm certainly a master...

Vinu512 is on the right track, and there are ways that you can set up these tables better to resolve your issue, but a better understanding of the scenario would...

Thanks for the reply.

Splitting the table into 3 won't resolve the issue.

The problem is that I don't have a table keyed StoreId/CategoryId so I've nothing to constrain against.