Dynamically get an associated field?
This is a slightly convoluted scenario. I'll do my best to describe the situation. I have two tables with related but not identical data. The project number is the key in the Projects table and the...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI read the post a few times, but could not understand what relationship if any the locations numbers had to anything. I could not tell if they were a separate table or just a field on the Activity Record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The data is in two tables, a Projects table using the project number as the key and an Activities table using the activity number as the key. The Activities table is a child of the Projects table. There are frequently multiple activities for each project. I need to find a way to get the location number from the activity into the Project table. While I'm talking about this relationship, I also need a way to associate the activity status of ALL activities to the project number. (this association would be based on the location number)
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
- MarkShnier__YouThat would just be a regular combined text summary field. If the location number is a numeric field, then you will need to use a formula field and ToText (. ) to change it to text to roll it up.
if you don't like the pill appearance, then there are easy formulas to change the appearance depending how you want the locations separated, like with a space or a comma space, or vertically separated.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- The Activities table is the child in this relationship. I need to get the data into the parent table. A summary field does not appear to be an answer.
------------------------------
Paul Peterson
------------------------------- MarkShnier__You
Re. A summary field does not appear to be an answer.
Why not?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------