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 m...
Forum Discussion
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
------------------------------
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
Qrew Legend
Qrew LegendTry 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
------------------------------
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
------------------------------