Discussions

Expand all | Collapse all

Auto-populate Grandchild records in grandparent view

  • 1.  Auto-populate Grandchild records in grandparent view

    Posted 22 days ago
    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.

    The unit is what they can choose from a drop down. So my units table can't be connected to my jobs table. I have a 3rd table now, tabbing table. This is the one that is connected to my jobs table, the user goes down and can select from a drop down all the possible units. It will then also auto-populate any other info about that unit.

    What needs to happen at this point is tricky and I could use some assistance with.

    Each unit has different materials associated to it that also need to show up in the job view. What's hard is each material can be used with multiple units and multiple units with multiple materials, a many-to-many relationship. 

    I need the materials to just auto-populate in the job view without anyone selecting them. 

    I tried the grandchild report through a report link but that doesn't work since the relationship between units and my many-to-many table can't be created due to the key field.

    I hope this makes sense. Happy to share my app if someone can be of assistance as well.

    Thanks!

    ------------------------------
    Nathan Allan
    ------------------------------


  • 2.  RE: Auto-populate Grandchild records in grandparent view

    Posted 21 days 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
    ------------------------------



  • 3.  RE: Auto-populate Grandchild records in grandparent view

    Posted 21 days 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
    ------------------------------



  • 4.  RE: Auto-populate Grandchild records in grandparent view

    Posted 20 days 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
    ------------------------------