I am relatively new to Zoho Creator but have some experience previously with other databases which may be confusing the terms I am using etc.

I was hoping that adding a sub-form would enable me to view records related by two linked fields on each form / table but this doesn't appear to be the case?

Is there a way to do this as I cannot find any options within the subform field settings.

Many thanks

John