Count Table of Display sizes by Location
I have 2 tables: Parent Table - Building related to child - Location related to child - Workstation Workstation Table has a field Display Monitor Size with values 22", 24", and so on. Currently t...
Forum Discussion
Do you mean that rather just have a summary report, you want an actual table with all the unique rows as records in the table.
So there are two steps. making the table and maintaining the table.
The making the table is easy but there is a trick. You need to create a key field for the table in the format.
Building Name-Department Name-Display Size.
So you create the table and make a field with that long name as the Key field and populate it by Creating a field in the details table with the formula
List("-", [Building Name], [Department], [Display Size])
and then making a summary report like you already did, except do it on that formula field. The use the more .. button to copy to another table.
The create a field called [Building Name-Department Name-Display Size exists?] as a formula checkbox field with a formula of true.
Then build a relationship back to the details table and look up that field.
[Building Name-Department Name-Display Size exists?]
Lastly fire an Automation that says when a detail record is created and
[Building Name-Department Name-Display Size exists?] = not checked, then add a record to the Summary table and populate that Key field with the value in the formula field.
You will then be able to get your total counts from a summary field on the Relationship and they will be self maintaining.
The making the table is easy but there is a trick. You need to create a key field for the table in the format.
Building Name-Department Name-Display Size.
So you create the table and make a field with that long name as the Key field and populate it by Creating a field in the details table with the formula
List("-", [Building Name], [Department], [Display Size])
and then making a summary report like you already did, except do it on that formula field. The use the more .. button to copy to another table.
The create a field called [Building Name-Department Name-Display Size exists?] as a formula checkbox field with a formula of true.
Then build a relationship back to the details table and look up that field.
[Building Name-Department Name-Display Size exists?]
Lastly fire an Automation that says when a detail record is created and
[Building Name-Department Name-Display Size exists?] = not checked, then add a record to the Summary table and populate that Key field with the value in the formula field.
You will then be able to get your total counts from a summary field on the Relationship and they will be self maintaining.