Does anyone know of any kind of system that can generate an update/insert/delete form (web-based or otherwise) from a mysql database that incorporates data from multiple tables that are linked by foreign keys? For example, a database with the following tables:

Table animals: 
id name species 
1 cookie 1 
2 james 2 
3 max  2 
Table species: 
id name 
1 rabbit 
2 dog 

would produce a form/s that allows
1) editing the species table
2) editing the animals table whereby you're given the option to either enter an existing species (via a select box or similar) or create a new one.

Am thinking that the foreign keys could be detected (if using InnoDB) or configured at the start (if using MyISam)

Someone must have come up with something like this & more complicated by now but i can't seem to find one, or i'm looking in the wrong places...

Any suggestions appreciated!