You will need to use a subquery in the condition that tests for not exists(foreign_key_in_other_table = this_table.id)
Michael
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks