+ Start a Discussion
clabiancaclabianca 

formula that pulls data from a different table

I want to create a formula that displays data from the account table on the opportunity table.  I tried putting

!tablename.fieldname and tablename.fieldname but when I check the syntex "error: field tablename does not exist."  But tablename is not a field it is the table.  I hope I am making sence here :)  Any suggestions.

SteveMo__cSteveMo__c

Can you post the exact formula that you are using? (use the Code Clipboard) or post a screenshot from your Formula Setup?

SteveMo__cSteveMo__c

Also, I would recommend using the Formula Wizard to make sure that the Object references and relationships are valid.

PilkoTechPilkoTech

Look at "cross object formulas" in SFDC help.  You should be able to use something like {!Opportunity.Account.City} to return the Account's city from inside the Opportunity tab.