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! =)
