Skip to main content
Question

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

  • May 10, 2017
  • 0 replies
  • 26 views
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 will look for duplicates in "Table B" and bounce back an error message or something if the 'Agency Name: already exists in "Table B"? Thanks guys
      This topic has been closed for replies.

      • EricJHansen
      • Quickbase Alumni
      • May 10, 2017
      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. 
      If the Agency name in Table B was able to be set up as the Key field on Table B, then upon saving a record in Table A, there  can be a message saying that the Agency name already exists.  If the Agency name cannot be the Key field - say that it is in fact the Customer Name and you are logging leads in Table A and don't want to duplicate exsting customers as leads, then you can do a Sync table of the customers and make the Key field in the Sync table be the key field.

      That can be done natively with no script.
      • EricJHansen
      • Quickbase Alumni
      • May 10, 2017
      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.
      Terms & ConditionsAccessibility statement