Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
The only way i know to do that natively, is to make a Table of Unique URIDs. Make the Key field be the URID #
Then make a Summary report grouped by URIDs in the details table and use the More button to copy to another table - and copy these unque URIDs to that table.
Then make a relationship back to the details table and make a summary of the # of details for each URID. Then look that summary field up down to the details record.
That will work fine, except that you will need to update that table of Unique URID each day or so - or unless you have some other way of ensuring that the URID table has a list of all possible URIDs.
Then make a Summary report grouped by URIDs in the details table and use the More button to copy to another table - and copy these unque URIDs to that table.
Then make a relationship back to the details table and make a summary of the # of details for each URID. Then look that summary field up down to the details record.
That will work fine, except that you will need to update that table of Unique URID each day or so - or unless you have some other way of ensuring that the URID table has a list of all possible URIDs.