I have a drop down called "Client Type" on my form.

One of the values in the "Client Type" drop down is "Realtor - Team" and the other is "Retail".  If I select "Realtor - Team", I am showing a field called "Team Name".  This field has the "No Duplicate Entries" check box selected.

Here is the problem, if I select "Retail", this field is not even shown.  However, when I try to submit the form, I am getting "Duplicate Entry For Key 3".  This validation should not even be checked for "Retail".  It should be checked only if the field is shown and the field is shown only for "Realtor - Team".

How do I solve this issue?

Thanks,
Ram.