Forum Discussion
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.
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.