Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started