Programatically unique

  • Thread starter Thread starter Jon Vaughan
  • Start date Start date
J

Jon Vaughan

Hi,

I have have dataset on the client side and I would like to set it up so that
it cant take data entered that isnt unique on two columns. There is
obviously the unique property of each column , but they work indepedant, im
looking for something that will be unique on more than one column.

Thanks
 
I would create an expression column which stores the result of concatenating
the two columns separated by a | character. Then make that column unique.
I'm not sure if you can make expression columns unique, but if you can, this
should work.
Otherwise, you can roll your own expression column by defining a column and
manually updating it to this value, and having this regular column be marked
as having to be unique.
 
Nice suggestion - Thanks

Marina Levit said:
I would create an expression column which stores the result of
concatenating the two columns separated by a | character. Then make that
column unique. I'm not sure if you can make expression columns unique, but
if you can, this should work.
Otherwise, you can roll your own expression column by defining a column
and manually updating it to this value, and having this regular column be
marked as having to be unique.
Click to expand...
 
Back
Top