This topic is locked
[SOLVED]

 Dependant Dropdown

2/15/2014 1:59:47 PM
ASPRunnerPro General questions
lefty author

I have Three tables
Photos Fields : fldbrand , fldsupplier , vendor_number , supplier_number
Brand_Supplier_Data Fields : fldbrand , fldsupplier
Supplier_CodesFields : fldsupplier , vendor_number , supplier_number
In the Photos edit page I have fldbrand setup to autofill fldsupplier from Brand_Supplier_Data

What I need to due is autofill _vendornumber and _suppliernumber which are not in the Brand_Supplier_Data Table above.
The 2 field names above are the same name in the Photos Table and Supplier_Codes Table

So I set supplier_number and vendor_number to be dependant upon fldsupplier.

I am only using the edit page in the Photos table and the data is copied from another table outside of this discussion.

When I open edit page the fldbrand data shows , the fldsupplier shows but the vendor_number and supplier_number are blank..

If I move up the dropdown to "Please Select" then select the only fldsupplier data that is there it fires the call and fills in vendor_number and supplier_number.That I want.
My problem is how do I get the dropdown of the fldsupplier to stay at "Please Select" so the user can then select fldsupplier and fire the vendor_number and supplier_number automatically. Seems since the fldsupplier is already filled in there is nothing to fire the fields unless I go to "Please Select" and then select fldsupplier data ; which then fires the 2 fields .

lefty author 2/15/2014



I have Three tables
Photos Fields : fldbrand , fldsupplier , vendor_number , supplier_number
Brand_Supplier_Data Fields : fldbrand , fldsupplier
Supplier_CodesFields : fldsupplier , vendor_number , supplier_number
In the Photos edit page I have fldbrand setup to autofill fldsupplier from Brand_Supplier_Data

What I need to due is autofill _vendornumber and _suppliernumber which are not in the Brand_Supplier_Data Table above.
The 2 field names above are the same name in the Photos Table and Supplier_Codes Table

So I set supplier_number and vendor_number to be dependant upon fldsupplier.

I am only using the edit page in the Photos table and the data is copied from another table outside of this discussion.

When I open edit page the fldbrand data shows , the fldsupplier shows but the vendor_number and supplier_number are blank..

If I move up the dropdown to "Please Select" then select the only fldsupplier data that is there it fires the call and fills in vendor_number and supplier_number.That I want.
My problem is how do I get the dropdown of the fldsupplier to stay at "Please Select" so the user can then select fldsupplier and fire the vendor_number and supplier_number automatically. Seems since the fldsupplier is already filled in there is nothing to fire the fields unless I go to "Please Select" and then select fldsupplier data ; which then fires the 2 fields .


Workaround. When Copying data to Photo Table ; Just did not copy fldsupplier. Now when on edit page Please select comes up with just one option as fldsupplier is dependant on fldbrand. When I select then select the data it fills the vendor_number and supplier_number . Must be another way but this works.