Details
Author: Jake Howlett
Date: 13 September 2000
Article: DFOU-4PRG6V
Category: Forms
Keywords: Keyword; JavaScript; Refresh; Dialog; XML;
Attachments
jsrefres12.zip (36 Kbytes)
jsrefres20.zip (39 Kbytes)

Keyword Refresh R2.0


This code example/template shows how you can use JavaScript to update the choices in a Keyword list that are dependent in a choice made in another multi-choice field.

This problem is one that is often referred to in many on-line discussions areas and yet has never had a decent workaround (in my eyes anyway). The fixes that have been suggested almost always involve the page being submitted to the server in order for it to reprocess the field values.

Version 2 of this database introduces XML and a new look. The database now only works in the browser.

image

The XML techniques used make use of XML Data Islands and the MS XML Parser. Using these Data Islands means that the we can overcome the 64KB limitation of using @DBLookups. Version 1 was limited by the number of options that could be returned for each drop-down.

Using the same principles we can extend this model so that when one select field is changed we can update numerous amounts of data in many different fields. Keep your eyes peeled for Version 2.x ...

Feedback:

Keyword Refresh R2.0
. . problems with accented characters (laurent bettembourg, Wed 21 Mar 2001)
. . Too many choices in Array?? (Jason Pattee, Wed 24 Oct 2001)
. . How to replace categorised views? (Andrei, Mon 21 Jan 2002)
. . Great tip but ... (Matt, Mon 4 Mar 2002)
. . . . Solution (Matt, Tue 5 Mar 2002)
. . Tip: using array's and javascript.. (Thomas Kruitbosch, Tue 2 Apr 2002)
. . . . ... that volkswagen URL no longer valid Jan 2003.. (Randal Oulton, Sat 25 Jan 2003)
. . Fantastic - great also for a web based NAB lookup (Ian Gallimore, Fri 5 Apr 2002)
. . Fill array when subcategories on seperate docs? (Michael Evans, Thu 18 Apr 2002)
. . . . Re: Fill array when subcategories on seperate docs? (Jake Howlett, Thu 18 Apr 2002)
. . . . . . Re: Fill array when subcategories on seperate docs? (Michael Evans, Thu 18 Apr 2002)
. . . . . . Re: Fill array when subcategories on seperate docs? (Ben, Tue 10 Jun 2003)
. . Help? (Dougal Campbell, Fri 16 Aug 2002)
. . Keyword Refresh 2.0 (Marlo, Wed 8 Jan 2003)
. . Does not recognize keywordArray (marlo, Thu 9 Jan 2003)
. . . . Re: Does not recognize keywordArray (marlo, Thu 9 Jan 2003)
. . Any idea how to cross reference for the drop down (Vic, Mon 31 May 2004)
. . 3 Keywords Refresh (Abdou, Fri 21 Jan 2005)
. . great idea, with a twist (Gregg Young, Thu 21 Apr 2005)
. . What about # of days between dates? (Marcy, Fri 22 Apr 2005)
. . js error - document has has no properties (Margie, Fri 3 Jun 2005)
. . . . Re: js error - document has has no properties (Joel Phelan, Fri 15 Jul 2005)
. . . . . . Re: js error - document has has no properties (Jake Howlett, Sat 16 Jul 2005)
. . . . . . . . Re: js error - document has has no properties (velu, Mon 25 Jul 2005)
. . . . Re: js error - document has has no properties (ravinder, Wed 31 May 2006)
. . Other Browsers Types (Simon Walker, Tue 20 Sep 2005)
. . . . Re: Other Browsers Types (Jake Howlett, Tue 20 Sep 2005)
. . Stop browser jump on Refresh fields keyword change (luc Betbeder, Fri 21 Oct 2005)
. . . . Re: Stop browser jump on Refresh fields keyword change (Maria Berlioz, Mon 30 Apr 2007)

Add your response here:

Name *:
Email:
Protected from spambots!
Remember My Details
Subject *:
Message:
HTML is not allowed and Passthru is disabled!
*=required