How can I create a calculated field based on a lookup?
Example:
If lookup = A
Then Value = 100.
If lookup = B
Then Value = 200
Etc etc.
This would be a Lookup to number or lookup to String procedure.
And how could i create a lookup to lookup calculated field.
Example:
Lookup contains two fields.
Distributor
Distributor type.
Where, if you choose the distributor, the distibutor should be selected automatically and viceversa.
Like
Dear Daniel,
You may use lookups "Cities" and "Countries" as example of such functionality or use business rules that will filter the second lookup according to value chosen in the 1st one.
Best regards,
Angela
Daniel Lira,
You can check those lookups in the lookups section, and to check the structure, please open them in Configuration. To find how they are named in configuration, you may check properties (http://prntscr.com/mesun6, http://prntscr.com/mesuud).