Highlight duplicates when two fields in one record are duplicate of another record within the same table

A record in Quick Base can�t really �see� other records.

So what I would do is to create a new table to record the Unique values of that field. To initialize the table, set a Text field in that new table called Unique values to be the key.

Then make a summary report in your details table and use the table to table copy option off the more menu to populate it.

Then make a summary count field and look that up down to the details table. If > 2 then duplicate.

Ok so now how to maintain that table?

I would make an Action to fire when the # of Uniue values is = 0 to create that Unique value record.

Thanks. I will try it!!

Thanks for the advice. I ended up creating a formula List field to concatenate two values. Then did summary report grouping on this new field, sorting descending by the Count. It gave me what I needed, anything over Count =1 I know is a duplicate and can drill down to investigate and correct. You saved the day once again!