| Re: form & lookup columns [message #172353 is a reply to message #172352] |
Mon, 14 February 2011 10:00   |
The Natural Philosoph
Messages: 993
Registered: September 2010
Karma:
|
Senior Member |
|
|
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.
> Thanks a lot
>
> Best regards
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]