How do I find records with no associated objects?

You will need to use a subquery in the condition that tests for not
exists(foreign_key_in_other_table = this_table.id)

Michael