I am using lookup function to pull a field from another table called "Info Part1".

The field that I am pulling has many records in it. Some of the records are duplicate. 

Now the lookup function is listing all the duplicates on the drop-down list. Is there a way to just list unique records in the drop down. 

Please see the attachment for details. 

Thanks!

Vishal