+ Start a Discussion
BpositiveBpositive 

Formula query

I have an entity which has two values, say automobile - Car and Bike. If I select Car, Car lookup should be active.

If I select Bike, Bike lookup should be active. Or if this is not possible, if I select a wrong lookup, say I select Car and do a lookup for a bike, it should give me an error. Can someone please suggest how will I be able to do this?

 

Please help.

 

Thank you in advance.

 

~BPositive

@anilbathula@@anilbathula@

Hi BPositive,

 

This can done with the visual force page rerendering.

I think Automobile is a picklist value.

Based on the selection inthe picklist value u can rerender the fields in the VF page.

Other wise u can use lookup filters for bike and car .

Where if u click bike lookup only Bike Details will appear not car details.

Same as for cars also.

 

Thanks

Anil.B

_Prasu__Prasu_

You cannot make active or inactive on Standard page layout. For that you can use the VFPage option as suggested  in above post. Or you can write a validation rule which check the picklist value and check if apropriate field has value or not.

BpositiveBpositive

Please help me with the validation rule. 

BpositiveBpositive

Please help me with creating those lookup filters.

AmitSahuAmitSahu

As per my understanding :

 

You can have two lookup fields.

" I have an entity which has two values, say automobile - Car and Bike (1st Lookup)

. If I select Car, Car lookup should be active.

If I select Bike, Bike lookup should be active. (2nd )"

 

(Say vehicle type )The 1st lookup - Car , Bike

(Say Vehicle Name) 2nd Lookup : Audi,BMW,Acura,Chevrolet,Harley,Honda,Suzuki

 

On 2nd lookup use 1st lookup field as parent.

Update the values so that when you select Car only car values are shown and if bike then only bikes are shown.

Till any one of the values Car/Bike is selected on the 1st field the 2nd field will be grayed out, by the way.

 

--- Declarative way of doing it. Else there is always a programatic way (for more control)... :) 

 

If helps ..good else ignore ...thanks..

 

 

BpositiveBpositive

Dear j020,

Got your idea. But i have the first one for Bike and Car as a picklist and not a lookup. Is that still possible?

AmitSahuAmitSahu
Pick list was required only ...dependent pick list ...