Filtering by many-Valued associations

BIZ TMS Aurelius
1
Hello everyone,

I have a problem while I search my database.
I should look for all records that do not have a reference, or a specific type of record, in another table. The two tables are associated with a "many-valued" relationship, and the table I am searching for is the one that has the record list of the other table.
I can not solve the problem, can you help me?

Thanks in advance
2

For searches like this is handy to create a bidirectional association, say Parent has a TList<Child>, but also Child has a reference to Parent. This way you can always start a query from any side and add criteria for properties in the associated objects.