
I have a dataverse table CnbTable with Columns Place (lookup column) and CnBOfficer(Lookup Column),
I have another table AssignCNB with columns Year , Location (lookup) , CnBUser(Text feild), I have to create a form in my model driven app where if I select Location as Bangalore it should auto populate CnBOfficer of that place in CnbUserText Field .
How do I achieve this in a model driven app
To achieve that, you need to write JavaScript on the AssignCNB form.
The script should trigger onChange of the Location (lookup) fields and if it contains data,