I am working with an application that has activities and subactivities; i.e. the activity table is tied to the subactivity table by a one-to-many relationship. I am looking for a way to efficiently summarize data from a text field in the subactivities table and associate it with the activity in a form and/or report. Similar to the way number type fields can be summed. Following is an example:
Activity 1
Subactivity 1.1 [strfield1.1]
Subactivity 1.2 [strfield1.2]
Subactivity 1.3 [strfield1.3]
Activity 2
Etc.
Note, that [strfield] 1.1, 1.2, 1.3 are the same field in different records.
How do I present this is a form or report as:
Activity 1: [strfield1.1] [strfield1.2] [strfield1.3]
In other words, having information (text fields) from different records appear on the same line.
Is my question clear?
I have been working around this for awhile but I would like to resolve it. I think I could do it with Dlookup, by scrolling through the number of fields in subactivity records associated with different activities but it does not seem an efficient solution.
Any tips?
Thanks
Activity 1
Subactivity 1.1 [strfield1.1]
Subactivity 1.2 [strfield1.2]
Subactivity 1.3 [strfield1.3]
Activity 2
Etc.
Note, that [strfield] 1.1, 1.2, 1.3 are the same field in different records.
How do I present this is a form or report as:
Activity 1: [strfield1.1] [strfield1.2] [strfield1.3]
In other words, having information (text fields) from different records appear on the same line.
Is my question clear?
I have been working around this for awhile but I would like to resolve it. I think I could do it with Dlookup, by scrolling through the number of fields in subactivity records associated with different activities but it does not seem an efficient solution.
Any tips?
Thanks