>Am I overlooking something? It's so hard to tell... Could you please post the entire schema? And then please say what "ran the test" means? We have no insight into what your program(s) are doing, but we can test the SQL - just paste the Schema and SQL that fails and we will be able to also run it and get the same error. This would make everything clear to everyone and then we'll be able to help you solve it fast and easily - now you're just prolonging your own agony. Help us to help you!