John Taylor-Johnston schrieb:
> I want to make a relational link from `data` to `shopping` so when I
> insert a new record in `shopping`, I will see the contents of
> `data`.`name` and `data`.`email` as drop-down menus in `shopping`.
>
> This is InnoDB so I should be able to do this by SQL, right?

where do you want to see this drop-downs?

MySQL is an database server, and i m not aware of any place where it would
display any drop-downs, possible you speak of some sort of GUI, like MySQL
Admin or phpMyAdmin?


--
Sebastian