• Replies 1 reply
  • Subscribers 1 subscriber
  • Views 70 views
  • Users 0 members are here
Options
Related

Combo Box

Admin
I am using an access database to store the monitored information.

I want to use the combo box object to select a class from multiple classes defined in the web studio; which triggers another combo box to contain the tags pertaining to the selected class in the first combo box.

As an example, The first combo box might contain classes such as inverter, loadcenter and other fields. When a person selects inverter then the second box displays the different inverter parameters such as output voltage, output current etc from where the user can select the appropriate parameter to display(graphical / a downloadable file) the information for the inverter.

Could you suggest how can it be done using the web studio?

Purnaansh
  • Create a table in your DB with columns "Class","Members","Value" and populate it with your equipment.
    Instead of a combo box, use a grid object in a dialog populated with "class" by executing a SELECT DISTINCT CLASS FROM MyTable.
    When a row is selected, copy "Class" to a string tag (sMyClass), close that dialog and open another with a grid object displaying "Members" by executing a SELECT MEMBER FROM MyTable Where Class = '{sMyClass}'
    User can then highlight a member to select it. copy the member name to a tag (sMyMember) and go get the "Value" WHERE Class='{sMyClass}' AND Member='{sMyMember}'.
    After your user changes a value, you can then write the value back to your DB(UPDATE ) the same row.

    This is the way I do a very similar thing, the Combo box has never worked too well for me.