When entering data in the data grid is there a way for me to pick the row in the table being referenced in Toad for MySQL?
For example, let's say I have an employee table with the "dept_id" column which references the "dept" table. This is setup as a foreign key constraint. When I'm entering data into the employee table is there a way to click on the drop down and have it let me select from the "dept" table and have the dept_id value inserted? Right now the drop down in the cell brings up a calculator.