You need to sign in to do that
Don't have an account?
Phuc Nguyen 18
compare field on grand child record to a different grandchild record
Hello All,
Trying to figure out how to compare a grand child record field to another grand child record field
Parent = Merch
Child = Invoice
grand child = invoice Line
Child = Purchase
grand child = Purchase line
I am trying to compare the merch category field on the invoice Line to the merch category field on the Purchase line.
Purchase is a lookup field on Merch.
Invoice records are related records on Merch.
Need to determine if there is a Purchase lIne record with a merch category value that is the same as the merch category on the Invoice lIne that is being created.
Just not sure how to query/map the record.
Thank you,
P
Trying to figure out how to compare a grand child record field to another grand child record field
Parent = Merch
Child = Invoice
grand child = invoice Line
Child = Purchase
grand child = Purchase line
I am trying to compare the merch category field on the invoice Line to the merch category field on the Purchase line.
Purchase is a lookup field on Merch.
Invoice records are related records on Merch.
Need to determine if there is a Purchase lIne record with a merch category value that is the same as the merch category on the Invoice lIne that is being created.
Just not sure how to query/map the record.
Thank you,
P
I have tried to solve the query... Please let me know if this is what you are looking for:
If you find the above solution helpful, then please mark it as Best Answer to help others too.
Thanks and Regards,
Suraj