Avoid duplicate entries

[Mono]

Hi
I am using a database join to join two tables as a one to many. tables 'customer' & 'operator'.

A customer can have many operators.

I have an 'operators' form with a database join to customer id and a repeat group for operator details.

Once a customer has had operator details entered, how do I prevent the user clicking 'add' and creating a duplicate of the original.

I would prefer that if when the user clicked 'add' and there is already an operator, that record would be displayed.
Is this possible?

 

[pyberg]

Have you made a unique index for the database column. It will then be impossible to enter the same value twice.

 

[Mono]

I'm not just sure what you mean, both tables have a primary key.

I could validate on uniqueness, but still I could end up with 'almost' duplicate records.
eg customer ______ _____operator
1 Pacific Rail___________1 Fred Smith
1 Pacific Rail ___________2 Frederick Smith

If the user comes to enter Frederick Smith and isn't expressly shown that Fred Smith has already been entered for Pacific Rail.

 

[troester]

There's an "areuniquevalues" validation to validate a combination of elements.

 

[bea]

I am not sure, if this is the correct hint:

Menu list/data/joins: You can select 'Merge rows and reduce data'