Using multiple dropdowns in browse screen

[n838901]

I am new to nuBuilder and new to SQL. I have gotten my form created and the dropdown works perfectly in the form. I followed the tutorial and added the SQL statement to allow my dropdown description field to be used in my browse screen, however, the tutorial doesn't explain how to use multiple dropdowns. I have been teaching myself SQL from various websites and forums, but nothing I have tried will work.

[admin]

n838901,

Do you mean what we call Listboxes.

http://wiki.nubuilder.com/tiki-index.ph ... uilderDocs

(BTW There is no automatic nuBuilder will save selections from a Listbox to a field in a record)

Steven

[n838901]

Yeah sorry, I should have elaborated more I created my lists and afterwards I created dropdown objects with SQL that pulls in the list data. I followed the tutorials to do that. The dropdowns show up in my form. I followed the tutorial video and used the INNER JOIN statement to add the description fields to the browse screen. That worked great, but I have quite a few other list fields as well and I have no idea how to pull from multiple lists from the same table.

[admin]

n838901,

It might be easier , if the lists don't change, that you make a separate table for each, then inner joining won't clash with field names.

Steven