Forum Discussion

MannyCruz's avatar
MannyCruz
Qrew Assistant Captain
9 years ago

Can a field in one table look for duplicates in a different table?

The field "Agency Name" in "Table A" is currently a unique field so you cannot input an agency in twice.  Can this field also check for duplicates in a different table? So it is a unique field that...
Eric_J_Hansen's avatar
Eric_J_Hansen
Qrew Cadet
9 years ago
This would not be a native capability. You could do it with a script after the record is saved, and it could check a box to alert you that it exists on a different table.