I’ve no idea whether this is the right place to ask - but here goes anyway.
Is there anyway to use a ‘where clause’ that applies to a field in a related table?
For example: Table A has a column linked to Table B via a 1to1 relation.
Can I find all the items in Table A, that have a specific value in the file they are linked to in table B?
What is the syntax for that request?