L
Linda
Guest
Hi, I have a table with several columns, five of which could have numbers. The first column must have a number, the other four may or may not have numbers. In all cases the number must not be duplicated. There are several validations in place, and everthing works well with current data. When I add a new record my "duplicate data" error message flashes and will not allow me to save even though I only have a unique number in the column that requires data. Through investigation I believe the "blank" fields are being seen as duplicated data. Am I correct in this and if so how do I get around it.
Thanks
Linda
Thanks
Linda