Forums » General Discussion

Thread: Pick row for column referencing using foreign key

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
nohkul

Posts: 2
Registered: 4/19/10
Pick row for column referencing using foreign key
Posted: Apr 19, 2010 3:09 PM
 
  Click to reply to this thread Reply

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)

Point your RSS reader here for a feed of the latest messages in all forums