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
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__You
Qrew Legend
Qrew LegendThat 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
------------------------------
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
------------------------------- I've been able to create a summary field in the Activities (child table) but I need it in the parent table.
------------------------------
Paul Peterson
------------------------------
