Hi Keith,

No, I think I couldn't explain correctly.

For example:

Table_A            Table_B
   ID              ID_Kind
   Name            Kind
   ID_Kind

In some cases, I want to accept a new record in Table_A just if the ID_Kind is already in Table_B.

In other cases, I want to accept a new record in Table_A if ID_Kind is NULL or ID_Kind exists in Table_B.

The first example, I called "1..n" and the second "1-0..n".

[]s!


>>Hi.
>>
>>I bought xCase last month just for help me, and I want to know if SQL Server can undestand the difference between a 1-0..n relation and 1..n relation.
>>
>>I added both conditions in xCase but the SQL script has the same sintax.
>>
>>TIA!
>
>Rudolfo,
>
>In SQL Server, the difference between one to many and one to zero..many is in the select query, not the table definition (INNER JOIN versus LEFT|RIGHT JOIN).
>
>Did I understand your question correctly?