Forum Discussion
NathanielHammer
6 years agoQrew Cadet
I also mentioned creating a work-order to create such smaller components. The best Example I can give is the same place where I am stuck in my app.
The electrical department builds our Control Panels with a work order.
The work-order tells them the amount and type of components to use.
- I have a table of all the electrical components, part numbers, price, mfg etc.
- I have another table that allows my electrical supervisor to create a work order. The form leads him to select the different options that a control panel can have and how many of each he wants in it.
Currently these two tables are unrelated. How do I go about getting every component to be related in the work order dependent on the type of component it is? I don't want any 'Ethernet switch' component to show up when I ask him what 'PLC' he wants to use.
I have to do this component selection process for about 35 fields in the form.
------------------------------
Nathaniel Hammersmith
------------------------------
The electrical department builds our Control Panels with a work order.
The work-order tells them the amount and type of components to use.
- I have a table of all the electrical components, part numbers, price, mfg etc.
- I have another table that allows my electrical supervisor to create a work order. The form leads him to select the different options that a control panel can have and how many of each he wants in it.
Currently these two tables are unrelated. How do I go about getting every component to be related in the work order dependent on the type of component it is? I don't want any 'Ethernet switch' component to show up when I ask him what 'PLC' he wants to use.
I have to do this component selection process for about 35 fields in the form.
------------------------------
Nathaniel Hammersmith
------------------------------
MarkShnier__You
Qrew Legend
6 years agoQuick Base nicely supports Conditional Drop downs. So, if you have selected in a field a type of PLC, you can then set the field for the drop down relationship to be conditional
Look for
The values in this field depend on a selection in another field
as a field property for the field [related component] - the reference field in selecting a part.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Look for
The values in this field depend on a selection in another field
as a field property for the field [related component] - the reference field in selecting a part.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------