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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the maximum number of applets can be there in a view?

583


Explain the use of detailed category in configuration?

487


What are the steps for creating a mvg?

664


What is if table in eim?

510


what is all mode sort?

602






How to Get the MultiValueFields in Workflow

1858


What is difference between s_opty_x and s_opty_xm tables?

624


Explain what is foreign key table in siebel?

566


Name the databases you have worked on?

580


What is the difference between eim and eai?

664


Explain how to import lovs?

541


Explain the use of catch in escript?

524


What is siebel?

605


Explain the difference between join specification and join definition?

516


Explain what is client business service?

554