I need to make my custom list items distinct that's being used for a dropdown lookup. Please help. Here's the scenario. I have 2 lists, the list1 have a workflow that copies an item into my list2. This happens whenever the user creates a new record in list1. Now, the problem is that I need to set up a duplicate check somewhere to ensure that list2 items are distinct or unique. I'm thinking if there's a way in sp2007 to loop through list items to check if my new item is already exists.
Below are my two lists. When the user creates new critical maitenance activity in list1 there's a workflow that copies the criticalmaintenace activity field automatically into my list2. Now if you can see the 2nd list, you'll notice that there's a duplicate items. I need to find a way to make the 2nd list unique because I'm using it as a dropdown lookup in other list.
Maintenance Activity (List1) NewForm
Activity : "activity1"
ACtivities (List2) (DispForm)
Activity
activity1
activity1
activity2