PhpMyAdmin foreign key issue - on create empty dropdown list -

i want create foreign keys. on same database, works, not... let take example:

table1, table2 , table3:

when want creat foreign key between table2.date , table1.date, works. between table3.date , table1.date. but, between table3.numero , table2.numero, doesn't work. when want creat it, dropdown menu empty :

any idea ? !

you might try add foreign key directly via sql.

alter table3 add foreign key (numero) references table2(numero);

in case phpmyadmin issue. tables should have innodb engine, think have done this.