In hierarchial picklist if we select Country as "USA" then we get sta

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

Question Posted / guest

4 Answers
8506 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In hierarchial picklist if we select Country as "USA" then we get state & City Values..

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

In hierarchial picklist if we select Country as "USA" then we get state & City Values..

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

In hierarchial picklist if we select Country as "USA" then we get state & City Values..

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

In hierarchial picklist if we select Country as "USA" then we get state & City Values..

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

Post New Answer