Discussions

Expand all | Collapse all

New Table as Parent or Child or Both?

  • 1.  New Table as Parent or Child or Both?

    Posted 02-22-2021 17:45
    Build Table has records that must capture a number of maps used in that Build.
    Maps Table has fields Map Name, URL Link, File Upload file attachment field.
    On the Build Table, I want to be able to multi-SELECT the Maps and then based on this selection, ALSO bring over the URL Links for the maps selected. 
    I tried setting Build as Parent and then as Child and then as Both with the Maps Table, but nothing seemed to work. 
    Any ideas?

    ------------------------------
    Ruby Kapil
    rubykapil@wi-finity.com
    Wi-Finity, Inc
    ------------------------------


  • 2.  RE: New Table as Parent or Child or Both?

    Posted 02-22-2021 17:49
    This sounds like you need a new Many to Many join table called Map Build Assignments and two relationships.

    One Build has Many Map Build Assignments
    One Map has  Many Map Build Assignments





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



  • 3.  RE: New Table as Parent or Child or Both?

    Posted 02-22-2021 22:36
    Hi Mark,
    I tried the join concept which I have done for other systems- maybe I'm getting tangled in my own head. If I add the Assignments as Child to Build and Map, or even as Parent, I still can't figure out how to make the pieces fit. With the join, then each Assignment will have 1 Related Build and 1 Related Map (if Assignment is child) or 1 Build will have a Related Assignment and 1 Map will have a Related Assignment (if Assignment is parent). 

    a. A Build can select any number of maps.
    b. A Map can be chosen over and over again in any combination with other maps for a Build.

    Build 1 has Map A, B, C, D
    Build 2 has Map A, C
    Build 3 has Map C, D
    etc

    I want to make it easy for user to select multiple maps for a Build with behavior as a Multi-Select field
    Plus bring over the URL link associated with the map.

    Build 1 has Map A, B, C, D and will also show MapA_url, MapB_url, MapC_url, MapD_url

    Reporting is being done at the Build level.

    What concept am I missing here?
    Thanks for all the help.

    ------------------------------
    Ruby Kapil
    rubykapil@wi-finity.com
    Wi-Finity, Inc
    ------------------------------



  • 4.  RE: New Table as Parent or Child or Both?

    Posted 02-23-2021 08:15
    Try adding several Map assignments to a build.  

    Then put a the report link field on the Build form to show the selected Maps for that build.  Set the form to show the child Record on the form, and not just a link.

    The embedded report will have the lookup fields for the map name and the map URLs.

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



  • 5.  RE: New Table as Parent or Child or Both?

    Posted 02-22-2021 18:13
    Thanks Mark! I'll give it a try

    ------------------------------
    Ruby Kapil
    rubykapil@wi-finity.com
    Wi-Finity, Inc
    ------------------------------