How to define a custom field which its LOV is dependent on another field in the form
Summary:
Custom field added to form should hold LOV based on a query dependent on another field in the form
Content (please ensure you mask any confidential information):
I need to create a custom field in the Asset form which its LOV will be dependent on the Customer Account updated for that asset- the users will be able to choose in the customer field LOV one of the account's sites.
How to I defined this custom field? Formula/Choice list (Dynamic)/Other type?
How and where can I update the query that brings all customer site locations for that given Customer account on the asset?