I have a serial number field that can be null but cant be duplicated. Can anyone think of a way to set that up so it errors out ONLY when the number is the same. Remember NULL is ok. THANKS IN ADVANCE
For example in Microsoft Access you can define a unique key which ignores Null. If ASP-Runner now tries to put a duplicate serial-number in your database, you will receive an error FROM database. It's not possible for the user to get this record saved. Perhaps this will help you. Greetings Uwe Pfeiffer