Another question about combo Box

Archived from the Xataface Users forum.

Jean — Tue Jan 27, 2009 9:13 am

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 — Tue Jan 27, 2009 11:47 am

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 — Wed Jan 28, 2009 8:00 am

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

Jean