Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
rtyanasrtyanas 

Lookup Value

I have a parent/child relationship on a lookup table.  When I bring up the tab for the parent I get the child default auto number.  I can bring up the description when I hover ofer the auto number. 

 

What I want to do is get the description, not the auto number, when I list the parent records in the parent tab. 

 

Book Name    Type (Hard Cover/Soft Cover)

Book 1              0001

Book 2              0002

 

In the list I want the Type description (Soft Cover) and not 0001.  Is this possible?

 

Thanks.

 

 

arjunmarjunm

hi

 

change lookup child object to Data Type as Text .As u  mention as Data Type as Auto number change as Data Type as Text

 

 

 

Thanks

arjun
rtyanasrtyanas

Thanks Arjun,

 

Do you have an example?

 

 
arjunmarjunm

hi rtyanas

 

In lookup object it brings auto numbe or name of the  Records, it will not bring any otherfields

 

try this one

 

your name-->setup-->create-->click   Type  custom object
Custom Object Definition Detail   click Edit
in  Data Type change the Auto Number as Text
and click save

 

Thanks

arjun

 
rtyanasrtyanas

Thanks for your guidance.

Went to:

Setup -> Objects ->  Object (parent) ->  Custom Fields & Relationships -> New -> Formula -> Text -> Insert Field

Then choose the field in the parent which will let you select the look up table then simply choose the description field.