populate select box with values from another table
populate select box with values from another table

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.