ie: parent record has 3 child records with RIDs 1, 2 and 3. I need a field in the parent record that would list these RIDs for a report.
Currently, if I export the field that is used to display the report in QB, the RID of the parent record is exported.
Currently, if I export the field that is used to display the report in QB, the RID of the parent record is exported.
- 0 Points
Posted 2 years ago
QuickBaseCoach App Dev./Training, Champion
-
59,768 Points
Is there a practical maximum to the number of health records? Well they're always be a maximum of only three records? Also what format would you like these three record IDs listed, would they be in three separate fields of the parent record?
QuickBaseCoach App Dev./Training, Champion
-
59,768 Points
Basically its this.
Make a summary maximum field on the left side of the relationship for the Minimum of the [Record ID#]. call it [Child Record ID# 1].
Then look that up down to the child record.
Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 1]. call it [Child Record ID# 2].
Then look that up down to the child record.
Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 2]. call it [Child Record ID# 3].
Y'ur done!
Make a summary maximum field on the left side of the relationship for the Minimum of the [Record ID#]. call it [Child Record ID# 1].
Then look that up down to the child record.
Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 1]. call it [Child Record ID# 2].
Then look that up down to the child record.
Then a new Summary of the Minimum Record ID#, subject to the condition that the [Record ID#] is grater than the [Child Record ID# 2]. call it [Child Record ID# 3].
Y'ur done!
Related Categories
-
Data import & export
- 708 Conversations
- 17 Followers
-
Relationships
- 2569 Conversations
- 40 Followers
-
Reports & charts
- 3021 Conversations
- 86 Followers
-
Tables & fields
- 7106 Conversations
- 162 Followers