| Re: form & lookup columns [message #172361 is a reply to message #172357] |
Mon, 14 February 2011 10:54   |
The Natural Philosoph
Messages: 993
Registered: September 2010
Karma:
|
Senior Member |
|
|
Captain Paralytic wrote:
> 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.
Bugger, Captain, that is what I meant.
If you can fill him in on that..I'll step back.
Not having ever used it, I am off my sphere of competence.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]