How can you test if Record1 and Record2 are identical? The following gives an error 'Invalid argument type'
If(Record1=Record2, "Identical", "Not identical")
For a practical example, this also gives the same error of 'Invalid argument type'
Gallery1.Selected = First('[dbo].[Transactions]')
Where Gallery1.Items = '[dbo].[Transactions]'
It seems that there is no comparison operator for records.
Please provide some guidance.
@AndyPennell may be interested in this.
PS Here is the work-around, but obviously not very satisfactory
Record1 in Table(Record2)