Working with related records
Hello
1. I have an opportunity 'Opty1' with picklist field 'plContract'. In 'plContract' I choose value from Contracts (custom object type).
Is there a way to get values from related contract (based on 'plContract' value) from opportunity 'Opty1' using workflow?
i.e. I want to get contract number (or end date, etc.) via workflow running on the opportunity.
2. I tried to use JoinFieldValue but i couldn't find which fields are foreign keys so here is my 2nd question:
how I can determine which fields in record types are foreign keys?
Thanks!
P.S. First to give a correct answer wins 10 points!