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 V3(mserp), Customers V3(mserp). Last two are virtual tables.
In SMART Audit Customers, I have arb_Customer lookup column, whose related table is Customers V3(mserp). In SMART Audit Customers table it shows 2 'Customer' name relationship - first is arb_SMARTAuditCustomers_Customer_mserp_cu (related table Customers V3(mserp) with many to one), second is arb_smartauditcustequipments_Customer_arb_sma (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 V3(mserp) 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 arb_Customer (Lookup column that is looking to Smart Audit Customers table),arb_SerialNo (Lookup column that is looking to the Assets entity view V3table).
So it means Smart Audit Customer Equipment has a relationship with Smart Audit Customers & Assets entity view V3,but there is no relation between Assets entity view V3& Smart Audit Customers.
We want to filter this arb_SerialNo dropdown which shows the 'Existing Assests' view from Assets entity view V3(mserp) 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.
 I have the bellow tables in my dataverse , model driven

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!