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?
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?