I have the order table in that if I open a form order.no field should appear if I enter a same order.no for the second time it shows the text “its a duplicate” and save the form I tried (I create the virtual column type show and write the content “its a duplicate” but I don’t know next) what to do?
In the virtual column and its Show? option, write a formula something like..
AND(
[_THISROW_BEFORE].[ColumnName]<>[_THISROW_AFTER].[ColumnName],
IN([ColumnName],TableName[ColumnName])
)
The 1st line is needed if you modify the record later and change the order number.
The 2nd line checks if that vaue exists already or not