<p>companyID=261 has the following for tier1. If SubCategory is different then tier1 can be same.&nbsp;(e.g. We can have Quality manager as a permanat employee and we can have Quality manager as temporary Employee also.&nbsp;</p>

<p>Now if you want to impose the rule that no where a duplicate should be created then we should warn the user not to create it when he is creating it. Which would be I guess simpler. So lets not allow the user to create an entry in the same tier if it already exists.</p>
