Hi Everyone,
I want to make my one query field unique. (Lets say the name of the query field "B"). This field (B) is coming from first 5 charachter of another field (lets say, field is "A") which is a member of a Table (lets say for table name "C")
So the query is calculated = left([A];5). Table field have totaly 9 charachter which is also unique value itself. In a form (Lets say the name of the form is "D") this query field (5 charachter one) is also shown to the users.
And as I said, when user enters the value in the form to "A" field , if the first 5 charachter exist before which generates my query, then database should give a message that says "there is existing record in query" and also not allow to make this record.
I could not succeed and appreciated any help.