Forum Discussion
You can make up a table of Standard rooms types. That table would have a child table or Required Std Equipment. The net result is that you would have a table of required std equipment with two columns - the std room type and the equipment.
Then you can set up Automation to to copy records from that Std Room Equipment table subject to a filter off the trigger record that the room type on the record matches the room type of the std equipment record and be sure to populate the field for related room so the child records get attached to the room and are not Orphans.
Post back if you get stuck.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Greetings
Thank you for your responses. Yes, the ultimate goal is to have pre-set standards based on room type that would populate the associated hardware when I add it to a report.
I am somewhat of a novice to the automation and relationship creation so what you described in your second post is a bit confusing for me.
If you do not wish to receive promotional materials from Ingram Micro via e-mail, please go to http://www.ingrammicro.com/emailmgmt or reply to this message and type unsubscribe in the subject.
Ingram Micro Inc.
Corporate Headquarters, 3351 Michelson Drive, Suite 100, Irvine, CA 92612
This email may contain material that is confidential, and proprietary to Ingram Micro, for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
[Ingram_2818e5de]
------Original Message------
I slept on this and realized there is a no code solution using Automations.
You can make up a table of Standard rooms types. That table would have a child table or Required Std Equipment. The net result is that you would have a table of required std equipment with two columns - the std room type and the equipment.
Then you can set up Automation to to copy records from that Std Room Equipment table subject to a filter off the trigger record that the room type on the record matches the room type of the std equipment record and be sure to populate the field for related room so the child records get attached to the room and are not Orphans.
Post back if you get stuck.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
Well we can continue slowly on this forum or you can book an hour with me and we will get it all working on a Go To meeting screen share session. www.QuickBaseCoach. com
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- CharlesWade6 years agoQrew Member
Well if this is free then sure. This is an application I am building as a tool for my role.
Whatever details you can provide regarding steps is greatly appreciated. I have a table already for room standards. Just need details on how to fill it with the hardware data
If you do not wish to receive promotional materials from Ingram Micro via e-mail, please go to http://www.ingrammicro.com/emailmgmt or reply to this message and type unsubscribe in the subject.
Ingram Micro Inc.
Corporate Headquarters, 3351 Michelson Drive, Suite 100, Irvine, CA 92612
This email may contain material that is confidential, and proprietary to Ingram Micro, for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
[Ingram_2818e5de]
------Original Message------
Well we can continue slowly on this forum or you can book an hour with me and we will get it all working on a Go To meeting screen share session. www.QuickBaseCoach. com
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Ok. Can you tell me you current tables and their relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------