Alaska Software Inc. - Comboboxes
Username: Password:
AuthorTopic: Comboboxes
Vladimir IahnencoComboboxes
on Thu, 02 Sep 2004 23:19:19 -0400
Hi All,
Have a database more than 1 MB length with index key FIELD1+FIELD2+FIELD3
Have 3 comboboxes
1. To select FIELD1
2. To select FIELD2 from scope FIELD1==ComboBox1.value
3. To select FIELD3 from scope FIELD1=ComboBox1.value and
FIELD2=ComboBox2.value

I'm trying to implement this using onChange=document.cookie +
location.reload() to set combobox values from scopes.
Does any other solution exist?
--
Regards,

Vladimir
Phil Ide
Re: Comboboxes
on Fri, 03 Sep 2004 10:41:49 +0100
Vladimir,

> Hi All,
> Have a database more than 1 MB length with index key FIELD1+FIELD2+FIELD3
> Have 3 comboboxes
> 1. To select FIELD1
> 2. To select FIELD2 from scope FIELD1==ComboBox1.value
> 3. To select FIELD3 from scope FIELD1=ComboBox1.value and
> FIELD2=ComboBox2.value
> 
> I'm trying to implement this using onChange=document.cookie +
> location.reload() to set combobox values from scopes.
> Does any other solution exist?

Yes - you could use Java or ActiveX controls to bind the field to a
datasource.  That way, when one field gets updated you should be able to
trigger the Java/Ax objects to reload values from the datasource and update
fields on the page.

I've never done this, so I can't tell you exactly how it is done.

The method I us is similar to yours but with a simple twist:

(this is function MyFormCreate())

  cManuFact := httpDefVar(MANUFACTURER,'')

  FORM START name=myform
     HIDE WAA_FORM=SubmitMyForm

     PICKLIST name=MANUFACTURER ;
             onChange='document.myform.WAA_FORM.value=MyFormCreate;'+;
                      'document.myform.submit()'
     While !MANUFACT->(Eof())
        OPTION MANUFACT->COMPANY SELECT (MANUFACT->COMPANY == cManuFact)
        MANUFACT->(dbSkip())
     Enddo
     PICKLIST END

This changes the form-function that is called when the form is submitted,
and also causes the form to get submitted.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

Situation normal: I don't know what I'm doing.
Anand GuptaRe: Comboboxes
on Tue, 21 Sep 2004 11:04:26 +0530
Hi

I have used IFRAME's for the same 2 years ago. Check out
www.coralindia.com/aceweb/
Select the demo company and check the Masters/G-Ledger option. Here the
Subgroup's changes as per the Groups.

I have a GROUP.DBF and a SUBGROUP.DBF pointing to the GROUP.DBF's GR-CODE

Anand

NB: Excuse me for a delayed response.

"Vladimir Iahnenco" <vladimir.iahnenco@scancode.com> wrote in message
news:KEmnJTWkEHA.5064@S15147418...
> Hi All,
> Have a database more than 1 MB length with index key FIELD1+FIELD2+FIELD3
> Have 3 comboboxes
> 1. To select FIELD1
> 2. To select FIELD2 from scope FIELD1==ComboBox1.value
> 3. To select FIELD3 from scope FIELD1=ComboBox1.value and
> FIELD2=ComboBox2.value
>
> I'm trying to implement this using onChange=document.cookie +
> location.reload() to set combobox values from scopes.
> Does any other solution exist?
> --
> Regards,
>
> Vladimir
>
>
>