MySQL Gui Insert

does anyone know of some software that lets you insert rows by looking up the foreign key id’s. I am using innoDB with foreign key constraints and it would be sweet if i had an application to pull up the foreign key rows like access does or other db applications. The help is appreciated thank you

check MySQL Control Center. It is not bad.

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].

That program works well for inserting new rows but say i have a table that has the foreign key to a primary table and i want the foreign key to come in as a drop down list in the primary table when inserting. I know I can do it through PHP but then i have to program it all with while loops and that can take a while i have about 5 tables linking together with foreign keys

I don’t know any program which can do this.

But I doubt that the program also needs to achieve this with a loop.

Let’s see what other people suggest. :stuck_out_tongue:

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].