scripts and validating

[dstichbury]

Hi there,

Is there anyway I can use the 'unique' validation idea, but dependent on a combination of two fields, for example, say I've got two fields, ' Title' and Language'

I will need to create a new record for each new title, and it's corresponding language, but I want to make sure that I cannot create two records with the same title and language.

Would i need to write a script in order to do this?

Many thanks

[aaa]

Try to create calculation field Title_Language=Titli&"_"&Language.

Then create self relation by this field let his name is Self. Then your validation will be like this Count(Self::Title)<1.

[dstichbury]

Thanks - I understand the principal, would you mind briefly going over the second part, creating a self-relation and how I'd go about this?

Many thanks

Dominic