Thank you very much for your reply. It really makes sense to change the foreignkey, and have have changed this. The core of the problem however remains the same.
Everything works fine when only one reservation per house is entered. When I enter two reservations on one house, only one one of the two reservations is checked by the query. If i have for example two reservations on house 121 1. 12/03/2010 - 14/03/2010 2. 23/04/2010 - 26/04/2010 Only entry 2 is reviewed. When I enter a new reservation from 11/03/2010 - 15/03/2010 "it" says the house is available. Everything works fine with only one reservation per house. Rob -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.