I have a form where I enter different types of products for different countries. So the form has two fields: Country and Product.

I would like to make sure that there is only one product entered (no duplicates) for each country. I can't simply set the product field to unique, as this would not allow me to have eg. 'beef' in both Italy and Spain.

I there any way to have the system check whether a product already exists for a given country?

thanks,

Anne