I have a requirement that when a field is populated on an opportunity, other fields are populated on the opportunity with a related address from the populated field. The populated field is uniquely stored as an alias on the address table.
I was planning on using a combination of custom content and OnChange script to accomplish this. The problem that I am running into is that I am drawing a blank right now on how to query the database for the related address from custom content.
Can someone please shove me in the right direction. Thank you!!!