Question: I have the bellow tables in my dataverse , model driven app solution. SMART Audit Customers, SMART Audit Customer Equipment, Assets entity view V 3
I have the bellow tables in my dataverse model driven app solution.
SMART Audit Customers, SMART Audit Customer Equipment, Assets entity view Vmserp Customers Vmserp Last two are virtual tables.
In SMART Audit Customers, I have arbCustomer lookup column, whose related table is Customers Vmserp In SMART Audit Customers table it shows 'Customer' name relationship first is arbSMARTAuditCustomersCustomermserpcu related table Customers Vmserp with many to one second is arbsmartauditcustequipmentsCustomerarbsma related table SMART Audit Customer Equipments with one to many relationship
When we click on new record in mda, SMART Audit Customer form opens up and shows Customer column under Finance and operations which relates to Customers Vmserp table.
We will choose the from the Customer dropdown and click on New SMART Audit Customer Equipment button, which will open the new form of SMART Audit Customer Equipment, this table has arbCustomer Lookup column that is looking to Smart Audit Customers tablearbSerialNo Lookup column that is looking to the Assets entity view Vtable
So it means Smart Audit Customer Equipment has a relationship with Smart Audit Customers & Assets entity view Vbut there is no relation between Assets entity view V& Smart Audit Customers.
We want to filter this arbSerialNo dropdown which shows the 'Existing Assests' view from Assets entity view Vmserp table.
We want to filter this dropdown so that it shows record related to only that Customer that we selected in SMART Audit Customer form under Finance & operations.
Please give the JS code for this and also let me know where and which function to pass as event handler in the form.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
