Search the Community
Showing results for tags 'subsummaries'.
Found 1 result
I've got a Subsummary layout. The layout is based upon the table, lets call it "Materials". The subsummary part is sorted-by the field "Type". Type can have say, one of three possible values in it: Glass, Paper, Plastic. When we sort this layout, we get subsummaries by the types, Glass, Paper, and Plastic, as expected. There's a script that performs some Finds, based on user-entered criteria, to narrow down that list. What I need to do now is have a script gather the IDs of only the records under, say, Paper. And only Paper. Suppose three records are showing under Paper, I want those three records' IDs in some form or another. So far I've only been able to have it gather ALL of the IDs in the whole table (wrong), or, only gather the first ID under the subsummary part (also wrong). My third method works and returns the desired results, but feels "dirty", so i hope to hear about a better way. That is, I perform a Find based on the last known Find criteria, adding in to that mix, the ID of the subsummary part they chose (=Paper), to actually go find and truly isolate those three records in question, then I can gather their IDs. But that throws off my Found Set, is slow, and requires more work afterwards to restore the layout to how it was before. Not a great solution either. Any input would be appreciated. Thanks!