At 12:12 PM 22-02-01 +0200, you wrote:

>I have also tried to completely rename the tables and fields by adding
>a 1 to each name that still does not work. This leads me to
>conclude that somewhere there is a serious error in my database.
>
>For the time being I am going to recreate my database and pump
>the data over while it still works. I would still appreciate
>comments suggestions as to how to prevent/fix this.
>
>Thanks
>Gerhardus

I think it is very bizarre to make a composite primary key on the detail table AND to make one of the columns of that key your foreign key. What is your reasoning for that? What does WONO add that BMNO doesn't do on its own?

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________