New Table as Parent or Child or Both?

Question

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

markshnier__you · Answer

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 · Answer

Thanks Mark! I'll give it a try------------------------------Ruby Kapilrubykapil@wi-finity.comWi-Finity, Inc------------------------------

rubykapil2 · Answer

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).&nbsp;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, DBuild 2 has Map A, CBuild 3 has Map C, DetcI want to make it easy for user to select multiple maps for a Build with behavior as a Multi-Select fieldPlus 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_urlReporting is being done at the Build level.What concept am I missing here?Thanks for all the help.------------------------------Ruby Kapilrubykapil@wi-finity.comWi-Finity, Inc------------------------------

markshnier__you · Answer

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

Forum Discussion

New Table as Parent or Child or Both?

Related Content

Totaling Child Records Live on Parent Form

Many parent records on a single child record

Add child record through parent form and redirect back to parent form in edit mode

Pipeline to add Parent record from child import

View all Parent records and related Child records in single table view