Hi there,
I want to make a field in a database a unique field, so no one can enter a duplicate value. The unique field will be for an invoice number. In some instances however, when the record is created we do not have the invoice number yet, so we need to come back to that record at a later date when we have received the invoice number.
The only problem is, is if I set the field properties so that no duplicates are aloud, then when nothing is entered in that field it comes back with an error for that record because null value is not allowed. We can't put a dummy code in that field as someone will inevitably duplicate what someone else has put in there.
Is there a way to set up the field to ensure no duplicates are allowed, but to ignore the field if nothing is entered?
I want to make a field in a database a unique field, so no one can enter a duplicate value. The unique field will be for an invoice number. In some instances however, when the record is created we do not have the invoice number yet, so we need to come back to that record at a later date when we have received the invoice number.
The only problem is, is if I set the field properties so that no duplicates are aloud, then when nothing is entered in that field it comes back with an error for that record because null value is not allowed. We can't put a dummy code in that field as someone will inevitably duplicate what someone else has put in there.
Is there a way to set up the field to ensure no duplicates are allowed, but to ignore the field if nothing is entered?