|
Replies:
0
-
Pages:
1
|
|
|
Posts:
2
Registered:
4/19/10
|
|
|
|
Pick row for column referencing using foreign key
Posted:
Apr 19, 2010 3:09 PM
|
|
|
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.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|