| Re: form & lookup columns [message #172357 is a reply to message #172353] |
Mon, 14 February 2011 10:30   |
Captain Paralytic
Messages: 204
Registered: September 2010
Karma:
|
Senior Member |
|
|
On Feb 14, 10:00 am, The Natural Philosopher <t...@invalid.invalid>
wrote:
> Wolf wrote:
>> Hi,
>
>> I've got a database with these tables:
>
>> Region (id, name)
>> Province (id, id_region, name, shortname)
>> Town (id, id_province, name)
>> Shop (id, id_town, name...)
>
>> I've made a form and I'd like that when I choose a region, in the next
>> drop-down menu I want to show provinces of that region
>
>> I've searched the web to study how to do this thing, but I haven't
>> found anything: could you please give me some hints/ideas/links to
>> tutorials?
>
> If you want that to hapen without submitting the page back to the
> server, you have two possibilitioes. One is a partial resubmit using
> IIRC Iframes, the other is to downlaod the whole bloomin lot and use
> javascript - and a lot of it - to dynamically change what appears on
> one box as a result of selecting in another, without reference to the
> server..
>
> This means effectively replicating a lot of what SQL does in javascript
> on data held in javascript arrays.
>
> It is not trivial.
>
> I am not clueful on iframes, but these may represent a simpler approach.
Actually you have forgotten AJAX.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]