Formula Queries - Entering Duplicates
I have a Clients table where Record ID# is the key field. My goal is to prevent a User from adding a Client that already exists in the system. I've set up a data form rule that works great for prevent...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think I missed a point in you post.
Try this
IF(IsNull([Record ID#]) and
Size(
GetRecords("{22.EX." & [SSN] & "}"),3)) >0, "A CLIENT ALREADY EXISTS WITH THIS SSN.")
That should mean that the test will only be active in Add Mode.
You can also have another field that does not block the save which is just informational.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Try this
IF(IsNull([Record ID#]) and
Size(
GetRecords("{22.EX." & [SSN] & "}"),3)) >0, "A CLIENT ALREADY EXISTS WITH THIS SSN.")
That should mean that the test will only be active in Add Mode.
You can also have another field that does not block the save which is just informational.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Hey Mark, I had sent you a private thank you but wanted to post the final formula here for others. Thanks again for your help!
If(IsNull([Record ID#]) and
Size(
GetRecords("{22.EX.'" & [SSN] & "'}")) > 0, "A CLIENT ALREADY EXISTS WITH THIS SSN.")
Todd
------------------------------
Todd Molino
------------------------------
