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
------------------------------