populate select box with values from another table

populate select box with values from another table

mmontoyammontoya Posts: 84Questions: 27Answers: 4

How do I make a select box which contains values from another table.
Also, I need the value to be the id field, but I need the display to be the text value: departmentID, DepartmentName

This discussion has been closed.