Solved: Preventing Duplicate Record - Page 2

MauriceWhelan · 10-15-2019 06:58 AM

Hi. I have a Product_Master_File table with a column [Raw Code]. I need to enter an expression in the Valid_If constraint to prevent the user submitting a Raw Code that already exists. I need to use another column in the table as the key field so I can’t set the [Raw Code] column as the key field.

Any help on this would be great.

Thank you.

Steve

Try:

ISBLANK(
  FILTER(
    "Product_Master_File",
    AND(
      ([_THISROW].[Raw Code] = [Raw Code]),
      ([_THISROW].[RowKey] <> [RowKey])
    )
  )
)

Replacing RowKey with the name of the key column of the Product_Master_File table.

View solution in original post