depends on the result you want. Both a script with Set field or an unstored calculation with a relationship might pull such data together.
List ( RelatedTable::Field ) will pull the data from field together in a single block with the text from each record separated by a return. Substitute can be used to replace the returns with other text if such is desirable.
The "list of" summary field might be used to produce exactly the same list, but via the context of the found set on a layout based on the HTML table instead of a related table.
Other options are also possible that use ExecuteSQL or GetNthRecord to pull the data from multiple records together.
I've never used either function before so I will give them a shot. I assume it's possible to filter results by a Primary Key.
Thanks for the quick response, and I'll let you know how it goes.
1 of 1 people found this helpful
You can filter results by any number of keys, not necessarily the primary key, but it's a good bet from what you describe.
Hot dam. The Set and List functions did the trick perfectly. THANK YOU!!!!