including related fields with summary lookups
I am using a summary date field to find the maximum value of certain fields in another table. I would also like to include some formula text fields contained within the related records. Is there a way...
Forum Discussion
Unfortunately it appears that only text fields can be summarized with this. I tried summarizing the formula rich text fields, which are displaying various colored icons depending on the date, but it includes every icon associated with the related employee.
What I have is a table [flight checks] containing date fields with due dates and rich text fields that create colored icons based on the due dates. On another table for the related employee [basic info] I have created summary date fields that find the maximum due date. I would like to include the colored icons from that record in the report that I have created on the [basic info] table.
What I have is a table [flight checks] containing date fields with due dates and rich text fields that create colored icons based on the due dates. On another table for the related employee [basic info] I have created summary date fields that find the maximum due date. I would like to include the colored icons from that record in the report that I have created on the [basic info] table.