Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
4 years ago

New Table as Parent or Child or Both?

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

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    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
    ------------------------------
    • RubyKapil2's avatar
      RubyKapil2
      Qrew Captain
      4 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        4 years ago
        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
        ------------------------------
  • RubyKapil2's avatar
    RubyKapil2
    Qrew Captain
    4 years ago
    Thanks Mark! I'll give it a try

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