I want to get the parent object field name in query string of child object

  • 1
  • Problem
  • Updated 1 year ago
  • In Progress
On Application object i have two lookup field

1.Account
2.Product(genesis__CL-Product__c)

Product(CL__Product__c) is parent to Account object. on account object having product(Product__c) lookup.

when i update account field, i want to display the Product(genesis__CL-Product__c)  from  on Account  Product(Product__c) field.

here i am writing my query string is like below

Product(genesis__CL_product__c) ==  {{$model.Account.data.0.genesis__CL_Product__r.name}}
.
Can any one help to get my product for above string.
Photo of raj

raj

  • 840 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of vicky singh

vicky singh

  • 240 Points 100 badge 2x thumb
1)Product(CL__Product__c) is parent to Account object. on account object having product(Product__c) lookup.

you want to say that product is master of account and again account is parent to product.Can you clarify this point?

2)when i update account field, i want to display the Product(genesis__CL-Product__c)  from  on Account  Product(Product__c) field.

It means that when you are going to update account field with product__c field on same time you have to update Product(genesis__CL-Product__c).Can you clarify those points.
Photo of raj

raj

  • 840 Points 500 badge 2x thumb
Hi Vicky,

Sorry for confusion,

Actually, custom object 1 have reference with Account, Account have another reference field have product and product have another reference field with custom object 2. here 2 scenarios

if  Account have product reference field not empty,

1. Custom object 1 have skuid page - in Model 1 have Account look up, once select Account record automatically auto populated custom Object 1 Product field from Account record product field value.

eg: Custom object 1.product = Account.product  

2. Custom object 1 have some other fields auto populated from custom object 2 related fields value means eg: custom object 1.field 1 = Account --> Product --> custom object 2 --> custom object 2 field value1.

like that will auto populated values from some related 2 objects to skuid page while creating custom object 1

Thank you for help