Using Tables to Populate ComboBox Menu

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I am creating a form that displays several ComboBox elements, I would like to populate the ComboBox with data from one column from another table.

After a choice has been made using the ComboBox I would like to use the relational data in the table to preform calculations, but for now I would just be happy displaying it.  Below is some pseudo code which hopefully clarifies my goal.

List<string> list = sqlCommand("SELECT keyColumn FROM table");

ComboBox.Items.Add(list);

if (ComboBox.Changed == true) {

string data = sqlCommand("SELECT otherColumn FROM table WHERE keyColumn = " + ComboBox.Value.ToString());

Lable.Text = data; 

}

I would like to link several tables in the same form in a similar fashion.  If someone could point me toward a tutorial to accomplish this, that would be great.  I feel like this should be a simple enough operation, but I cannot get a functioning example using the QuickBase UI.

Thanks

Photo of Peter

Peter

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
It sounds like you're wanting to do a Conditional Drop-down. This is accomplished by first creating a relationship between the two tables. Once you've done that, you can set a Condition towards the bottom of the Field Properties page for the reference field.