Question: I have 3 tables in my model driven apps. Smart Audit Customers, Customers V 3 ( mserp ) and Company Chains ( mserp ) .

I have 3 tables in my model driven apps.
Smart Audit Customers, Customers V3(mserp) and Company Chains (mserp).
In Smart Audit Customers, i have arb_customer (lookup to Customers V3 table), arg_type (a text column).
In Customers V3(mserp), i have mserp_companychain (text column).
In Company Chains (mserp), i have mserp_chainname and mserp_chaindescription both text.
write js in smart audit customers form so that arg_type should be populated.
When arg_customer field is updated:
Get Company Chain (mserp_companychain), from Customers V3(arb_customer).
Match Company Chain to Chain (mserp_chainname) on company chains entity (ARBsmmCompanyChainEntity) to get record. Populate Type (arg_type) on Smart Audit Customer using Description (mserp_chaindescription) from record.

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!