Hi Bill,
If you could verbalize what the end result should be in a little more detail, that will be helpful for us.
For example, is your end goal to pull the Organization__c field into the model you built on CR_Use_DNA__c? If so, you might not be able to use a subquery for this. The subquery condition would be useful if you were trying to filter CR_Use_DNA__c records based on the results of a subquery, but it wouldn’t pull in a field from another object into the model.
For example, if we want to pull in all Contacts whose Accounts are located in Japan, the subquery piece would create a temporary a list of Accounts who have a Billing Country = Japan, and then the Contacts model would pull in only Contacts whose Accounts were returned by the subquery
If the subquery isn’t working out, a UI-only formula field that uses a MODEL_LOOKUP might also be useful. See here: https://docs.skuid.com/latest/en/skuid/models/ui-only-models-fields.html?highlight=model_lookup#refe…
Because you’re traversing 3 objects (CR_User_DNA__c –> Contact_Record_DNA__c –> Member_DNA__c), the solution might involve the same number of layers, so understanding your goal more clearly will be important.
