Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Multiple Lookup


Recommended Posts

I am trying to get data to auto-populate via a lookup from either one of two fields that are populated. My example is when someone types in a Company ID in field one the Company Name and Address populate or if they skip the ID and just enter the Company Name then the Address populates.


(field a) XYZCO ------------> (field b) XYZ Company (field c) Main Street


(field b) XYZ Company ------> (field c) Main Street


Currently I have the Company name and address as a regular lookup from the ID but cannot seem to ge the address to lookup from the Company only.

Link to comment
Share on other sites

Use an auto-enter calc instead of an auto-enter lookup; your calculation can use Case, If, or Evaluate (or a host of other operators for that matter) to distinguish between one situation and another, and to auto-fill the value that's appropriate depending on the situation.


If you want it to update whenever the referenced fields get modified, as lookup fields would do, uncheck the checkbox "do not replace existing values).

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use