Another question about combo Box

[Jean]

Hi Steve,
I am building a menu like in the example of Province/City
http://xataface.com/forum/viewtopic.php?t=4150
I have 3 select boxes dependent on each other.
The difference with the province example is that they come from 3 different tables the first is connected with the second one in a table and the third one is connected with the second one in another table.
Do you think that to perform this trick, I need to have all my foreign keys in the same table ?
Thank you again
Jean

[shannah]

Hi Jean,

It should work without having the foreign keys all in the same table. Just as long as the city table has a fk to the province table, and the province table has a fk to the country table.

-Steve

[Jean]

Thank you Steve for your quick answer. Yes you are right, everything is in the example. I had an error in my code.
Jean