General information
Category:
The Mere Mortals Framework
Title:
Check for uniqueness
My form has a combobox control that can use lunique. The table I want to check uniqueness against has an index on the concatenation of 2 fields (regular index). I want to choose a value in the combo box, and check to make sure this value is not in another table for the customer I am on (i.e. the key is the customer id I am on and the value I am entering). Another way of putting it: The table I am adding to has a field for customer id and one for code. I want to make sure there are no dupe records.
I set lunique to .t. on the combo box control, set cView to a view I am creating. Not sure what to use for the filter (must use both fields) and what to use for cViewParameter for the control.
Anyone done this before?
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only