We have a relationship between Opportunity and Product. The account relationship within the product is used to record the account to which the goods are to be delivered. In most cases the products are delivered to the address related to the opportunity (Invoice Address).
What I want to do is add a tickbox/drop down which asks "is the delivery address same as Invoice address". If it is the Account_id field on the product should be hidden and the account ID from the opportunity defaulted in. If the user selects that the delivery address is not the same as the invoice address then the account_id field should be made visible and the user will go through the normal selection process.
The account_id field is a relationship field and therefore not available in the studio to add dependency. How else can I make this work?