In model driven app,

I have SMART Audit Visits table and in that

I have arb$\_$customer $($lookup to SMART Audit Customers table$)$

arb$\_$site $($lookup to Customer postal address table$)$

arb$\_$smartauditvisitsid $-$ guid

In SMART Audit Customers table $-$ we have

arb$\_$customer $($lookup to CustomerV$3$ table$)$

arb$\_$smartauditcustomersid $($guid$)$

we are in SMART Audit Visits form and

what we need is to get this arb$\_$customer$($lookup to CustomerV$3$ table$)$ of SMART Audit Customers table.

After getting this use this to filter arb$\_$Site $($lookup to SMART Audit Customers table$)$

so that it only show related record.

mserp$\_$customeraccountnumber in Customer Postal Address

mserp$\_$customeraccount in Customer V$3$

If $($mserp$\_$customeraccount$)$ has value C$-0002$ so arb$\_$Site should only show records filter by C$-0002$ in mserp$\_$customeraccountnumber.

Write JS for this, use retrieve record, presearch all we need.

Logical names for each table are please use these

SMART Audit Customers $-$ arb$\_$smartauditcustomers,

SMART Audit Visits $-$ arb$\_$smartauidtvisits,

Customers V$3-$ mserp$\_$custcustomerv$3$entity and guid for this $-$ mserp$\_$custcustomerv$3$entityid.

Customer postal address $-$ mserp$\_$customerpostaladdressentity.