How would I prevent duplicate entries into a list from being entered based on the status of a different item on the list. For example, I don't want someone to enter an new list item if they have an item with an open status.
Name Status
Jones, Open (new entry not allowed, duplicate value)
Jones, Closed (new entry is ok)