04-28-2010 11:06 AM
I Hope I understand you correct.
You would like to crete something like type and sub type in the account area?
If so, here is what you need to do:
Create the first picklist - the master one.
Map the picklist and bind it to yur db.
The second one has no picklist assigned to the control.
To make the web client handle this correct, open the quickform xml file, look for the picklist control and insert a picklistID tag with an ID of a picklist.
Then save it, open it up in AA and do your work on it.
Look at the pklsubtype of the account detail form.
You than need a rule which gets the correct picklist for your second one.
Also, you can look this up in the getSubtype method (do not remeber the exact name).
Set the onChange event of the master picklist to a refresh, and all should work.
Put code in to the load action of your form which set the picklist name of the child picklist using your method.
Hope this helps!