In hierarchial picklist if we select Country as "USA" then
we get state & City Values constrained to USA.
If we Select Country Other Than USA, We should get state ans
city values Empty How do we do this
For 1 reccord of Country we can do this using
OnFieldUpdateSet Bc UserProperties but if we want to do this
for 50 records how to do this
Answers were Sorted based on User's Feedback
Answer / rajesh
In this requirement we create dummy values in pickmap.
ex: while giving pickmap for COUNTRY---USA in that country field pick map we configure
field-country, picklist field - value
field-state, picklist field-dummy
field-city, picklist field-dummy
and we give pickmap for STATE-
field-state, picklist field-value
field-country. picklist fild-parent, constrained-true
field-city, picklist filed-dummy
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / harish velpula
Pick Map needs to be add at parent field level.
Go to Pick Map and give Field property only
Field - Child field name (State)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / taj
HI,
I didnt get your query.
if you wnat to make the state and city fields null if the
country is other than US then dont create any of the
country just create only one country LOV as US.
or
if you want to make state and city must be blank whenever
you change a country.
then crate a Dummy Calculated Field set value as "".
then create a pickmap under the Country FIeld as below
FIeld = State and PickList Field = Dummy
like this go to State Field Create a PickMap as below
field = City and PickList FIeld = Dummy
it works when you change a COuntry from US to Uk or India
the State and CIty bucomes Null. You have to pick the
values of the respective COuntry- State- City
IF your query is different than this then please let me
understand me.
BestRegards,
Taj
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / venkat
Create a Calculated field, with the values Yes/No.
If the Country is USA make it Yes or No.
Now you can use OnfieldupdaateSet BC userproperties as a
single field
| Is This Answer Correct ? | 3 Yes | 11 No |
How do you recognize that a particular table (base table) can be extended?
Why do we need to create employees at the database in siebel?
What is the difference between links and multi value links?
By what way do you give Responsibilities to employees in Siebel ?
Explain what is the significance of eapps.cfg file?
Explain why do we use symbolic strings in siebel 77?
in a three level hierarchial picklist say country,state,city how do we perform pickmap 2)say if we have values same for country (having value 'A') and for state (having value 'A') and for city having value 'B' and in parent Lic we give value for city as 'A' how do it recognise it as State any other solution
How to create Drilldown in Form applet?
what is the difference between join and link?
How to import list of values?
What is TPM ?
Explain how to find entity relation in siebel tools?