NetBeans makes it easy to create a Jtable and bind it to a table from an SQL database, thanks to TopLink Essentials.
...But how do I bind a column in the database to a particular table?
Let's say you have a table called Employees. Each row contains a unique ID#, a name (e.g. John Smith) and the ID of the employee's department. You may edit the table to change any of this information.
This table has been bound to a Jtable called EmployeesTable.
I would like to edit each employee's department not as a number but as a combobox populated with the department names (Sales, Marketing, etc.), pulled from another table (called Departments, let's say). When the user selects the department name, the ID# of the department should be fed back to the column in that row of the table.
Binding an SQL table to a JComboBox is trivial, thanks to the BeansBinding tools. However, I haven't figured out how to bind *all* entries in a column of a JTable that way.
I've been trying to figure this out since October, without success. *Any* advice would be appreciated. Although I'm not new to programming, I am new to Java. Thank you for your time.