You have to do this with Javascript http://176.34.12.39/welcome/en/static/js/location.js
That is how I am handling the situation where select a continent only the countries for that continent show in the select box. On Thu, Feb 9, 2012 at 4:53 PM, shartha <[email protected]> wrote: > Let's say the model has three tables, called country, cities and > customers that are defined like: > > db.define_table('continents', > Field('name'), > ) > > db.define_table('countries', > Field('name'), > Field('continent', db.continents), > ) > > db.define_table('customers', > Field('name'), > Field('country', db.countries), > Field('continent', db.continents), > ) > > Now if I check the "Database Administration", how can I set up the > customers table such that when I am inserting a record in the > customers table, if I select a country, the continent the country is > in is automatically selected? > > Under another scenario, imagine we first select the continent, then > the country and then enter the name of the customer, how can I set up > the model such that when the continent is selected, only the countries > in that particular continent are available to be selected? > > I am imagining that the counties and continents in the customers table > and the countries table are drop-down menus. > > Any help would be appreciated. Thanks! =) -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
