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
I think Mark and I interpreted the question 2 different ways. My interpretation was that when adding a new record on table A and entering a unique value into a field on table A, can that action also check EXISTING records in other tables to determine if that value already existed.
MannyCruz's avatar
MannyCruz
Qrew Assistant Captain
9 years ago
This is the question I intended yes. I was hoping a script page wouldn't be the way to go, but I think you are right. Thanks to the both of you guys! Always helping out