# Combination Of ProjId And ItemiD

**URL:** <https://www.dynamicsuser.net/t/combination-of-projid-and-itemid/32704>\
**Category:** Technical Forum\
**Created:** [September 6, 2011, 1:26pm UTC](https://www.dynamicsuser.net/t/combination-of-projid-and-itemid/32704 "2011-09-06T13:26:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ven\_BenZ](https://avatars.discourse-cdn.com/v4/letter/v/ed655f/32.png) [@Ven\_BenZ](https://www.dynamicsuser.net/u/Ven_BenZ)\
**Post date:** [September 6, 2011, 1:26pm UTC](https://www.dynamicsuser.net/t/combination-of-projid-and-itemid/32704/1 "2011-09-06T13:26:23Z")

</div>

For example :  
Projid Item

1 1

2 2

3 3

1 2

1 3

2 3

if

1 1 (duplicates not allowed);

_There should not be any duplication for **Itemid and ProjId combination** _

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [September 6, 2011, 1:32pm UTC](https://www.dynamicsuser.net/t/combination-of-projid-and-itemid/32704/2 "2011-09-06T13:32:48Z")

</div>

There is no question nor description where your problem is, but maybe you need to create an index with those two fields and set the index property “AllowDuplicates” to “No”.

If it didn’t help, try to describe your question more clearly.

---

<div class="post-metadata">

**Author:** ![Ven\_BenZ](https://avatars.discourse-cdn.com/v4/letter/v/ed655f/32.png) [@Ven\_BenZ](https://www.dynamicsuser.net/u/Ven_BenZ)\
**Post date:** [September 6, 2011, 1:45pm UTC](https://www.dynamicsuser.net/t/combination-of-projid-and-itemid/32704/3 "2011-09-06T13:45:55Z")

</div>

Ok…

My thought also same way but demo data not Available

ok thanks i’ll chek it BOSS