Forum Discussion

MichaelFrishma1's avatar
MichaelFrishma1
Qrew Cadet
4 years ago

New Formula Queries Don't Work when Adding Records?

I'm trying to use the new formula queries to prevent the addition of a new, duplicate record in my "Tours" table. There are reasons why I cannot just use the Unique flag... The Tour ID is the key f...
formula queries
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Try this.  I know the quotes are tricky.


Size(
GetRecords("{6.EX." & [Tour ID (Paste)] & "}"),3))

If that is 1 (or higher) when you are in add mode and not yet saved, that means it will case a duplicate.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------