Summary List Text, do not show repetitions.
I have a table of line items that are related to an equipment list table and sorted by category. From the equipment list layout, I want to see a list of the Categories used but i don't want to see the repetitions. I tried creating a Summary field of the categories in the line items table and checking the Sum repetitions field but it does not appear to function. Any thoughts? Thanks.
That new summary field includes the duplicates.
But a conditional value list might be set up to list the same values and then ValueList items will return the same list but with the duplicates omitted.
And ExecuteSQL might also be an option to consider...