Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To SQL

Authors: Frank Lusardi

1st Edition

0070390029, 978-0070390027

More Books

Students also viewed these Databases questions

Question

Explain the procedure for developing an aggregate plan.

Answered: 1 week ago

Question

Discuss the goals of financial management.

Answered: 1 week ago