For some reason I thought that in order to make a key foreign it
should be part of the primary key. I was wrong. It works witout
I am still fairly new to databasing and I work on my own so
there is nobody to ask. I also dont lik to ask to much questions
on the mailinglists because poeple tend to ignore you if you only
ask and dont answer. I do not have the experience or knowledge to
answer yet.
But all this still does not remedy my problem.
I will use the advice given to alter my primary keys of all
my detail table when I recreate my database.

Cheers
Gerhardus Geldenhuis



Helen Borrie wrote:

> 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
>

_______________________________________________________

> To unsubscribe from this group, send an email to:

ib-support-unsubscribe@egroups.com

> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>