Forum Discussion

NathanAllan4's avatar
NathanAllan4
Qrew Cadet
5 years ago

Auto-populate Grandchild records in grandparent view

I have a table labeled Jobs. Pretty basic. I have another table labeled units. Each User can choose from a drop-down which units are associated to the job. I've created that relationship already. T...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
It is not really clear from your post what tables you have and how they are related. Can you list all your tables and all their relationships making clear which is the One in which is the Many in the Relationships.?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • NathanAllan4's avatar
    NathanAllan4
    Qrew Cadet
    5 years ago
    The relationships are complicated. 
    Jobs <- Tabbing
    Jobs <- CIFA
    Units <- Tabbing
    Tabbing <- Multiple
    Units <- Multiple
    Materials <- Multiple
    Multiple <- CIFA
    Units <- Materials
    Units <- CIFA
    Materials <- CIFA

    Units table has all the possible units we could use on a job (249).
    Materials has all the possible materials that could be used on the job (94).
    Multiple has all the possible combinations of units and materials (320).
    Jobs has all our jobs we do.
    Tabbing is where the user will manually enter the units being used and the quantities.
    CIFA I'm not sure I need it, but I think I do. This would look like job #, then material information that was auto-populated based on the units selected.​

    Hopefully that helps.

    ------------------------------
    Nathan Allan
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      I'm sure that this is possible, but due to the complexity of the relationships and also that I'm unsure if you just want to see the materials on the job or actually create new records in a table, I thin that we would need to need to work one one one to sort this out.

      Either way,  would it be OK if the user had to push a button while on a  Job to see the required Materials?

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------