I have $4$ tables in model$-$driven apps.

Smart Audit Customers

Smart Audit Customer Equipment

Assets entity view V$3$

Customers V$3$

In Smart Audit Customer Equipment I have columns $-$ arb$\_$Customer $($Lookup column that is looking to Smart Audit Customers table$),$ arb$\_$SerialNo $($Lookup column that is looking to the Assets entity view V$3$ table$).$

So it means Smart Audit Customer Equipment has a relationship with Smart Audit Customers

& Assets entity view V$3,$ but there is no relation between Assets entity view V$3$ & Smart Audit Customers.

I have $2$ forms $-$ Smart Audit Customers $-$ in this I have arb$\_$Customer from which we need to filter that view. $($It$\text{'}$s Primary column in Assets entity view V$3$ table is mserp$\_$customeraccount$).$

Then on next form Smart Audit Customer Equipment $-$ I have arb$\_$Customer which is lookup that looks to Smart Audit Customer table and next is arb$\_$SerialNo column which looks to Assets entity view V$3$ and has view $-$ "Existing Assets" which we want to filter based on arb$\_$Customer of Smart Audit Customer.

Please give the whole JavaScript code for this issue.

I want that view to filter considering Finance & Ops Customer.

Please first give the whole code and after that also suggest me what to change when I implement in my solution.

On Smart Audit Customers we have a button that open the new Smart AuditCustomer Equipment form as shown in the picture, where we have arb$\_$SerialNo