Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

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 activity number is the key in the Activity table.  Additionally, the Activity table is a child table of the Projects table.  There is a location number in the Activities table that is associated with the activity number and there can be multiple location numbers at the same address because at one point the location number was associated with a particular device rather than the physical address.

What is the best way to dynamically associate the location number to each related project number.  One additional complication, it is possible (in fact probable) to have multiple activity numbers for each project number, although the location number ideally will be the same .

------------------------------
Paul Peterson
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    Would it be a good bet based on the lack of a response that this is not possible using Quick Base?

    ------------------------------
    Paul Peterson
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      I 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
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        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
        ------------------------------