I want a user to be able to firstly select a value from a picklist and then to be able to select values in a lookup.
For example, if the user selects the value "campaign" from the lead source picklist, I want them then to be able to select from the "primary campaign source" lookup drop down. (Both of these fields are standard fields on the Opportunity object).
However, this does not seems to be possible on account of the lookup not being a picklist, i.e., the dependent picklist functionality is truelly limited to picklists and does not extend to looups.
Am I correct in saying so? Is there an elegant workaround?