I am trying to load a lookup field from one of 2 tables depending on the user selection. The picture below explains more
Assign By has 2 dropdown options: lets call them Option 1 and Option 2.
If the user selects Option 1, I want to load the values in table 1 into the lookup field called Assign From and
if the user selects Option 2, I want to load the values in table 2 into the lookup field called Assign From
Is this at all possible? Loading the content of a lookup field on the fly?
Thank you