Chris,

Does the value in the datatype field affect what fields you are going to populate in that table? In other words, does a type "1" record use different fields than a type "2" or "3" record?

>I need to write validation code that will search for duplicate values within a field. The datatype of the field is c(1) and I have other code preventing users from entering anything other than "1", "2", or "3". Basically, I need to make sure only one "1" is entered, one "2", etc... for a set of records. I tried doing this by creating separate cursors that will hold each possible value (only up to three), scanning my view, and inserting the field values into the different cursors. If any of the cursors have reccount(csr) > 1, then error message. Unfortunately, this does not work.