Unique Values / Deduplication constraint

[Sly]

Hi!

I am discovering Corteza for the first time. Sorry, if my question looks stupid.

I have 2 tables.
Account and Solution.

An account can have multiple solutions (solution1, solution2, solution3).
But, each account can not have multiple time the same solution.

If I create a constraint, with fields account_name and solution_name to check.
This check account_name or solution_name instead of account_name and solution_name

For example, if the table Solution contains: “account1 solution1”
Adding account1 solution2 or account2 solution1 will trigger the duplicate filter.

I think the logic need to be a OR between constraints and a AND inside the constraint description.
Am I wrong?

Thanks for your help

[Sly]

Up!
Nobody have a solution for this?

[jfortun]

Edit module does not have validation tab

I have a module with 4 fields id1, id2, name, address. a record is unique when it is distinct combination is id1 and id2 together. i am trying to set this up and i dont see a validation tab, i only see unique values tab though i add id1 and id2 both under unique contraint #1 it still looks for uniqueness in id1 and id2 separately. please let me know how i can get around this.

This is relevant.
For your cases you need to use a workflow.