Subscribe system object has a text field "legacy ID". 1 account can have many unique legacy ID. I have a new object Sub Details wherer I want to populate a picklist/lookup containing all legacy ID upon choosing 1 particular account, so that I can choose a particular legacy ID.
I have tried the following:
- List itemtried formula field, but can't because there are many legacy IDs for 1 account
- Tried lookup from Sub Details to Subscribe system.
How to proceed?