Problem creating foreign keys

From: Lois Appleton <applet_at_mailhost.sasknet.sk.ca>
Date: 1995/09/13
Message-ID: <436384$h8l_at_tomcat.sasknet.sk.ca>#1/1

I'm trying to create a foreign key on a table. I have successfully created foreign keys on 11 tables using the data field client_number. When I try to create it on this table it fails telling me there is no matching values but I can do a join on the two tables using client_number.

The data field client_number has been defined the same on all tables.

Any ideas or suggestions? Received on Wed Sep 13 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Paul Singer: "Re: Using redo logs for a hot standby"
Previous message: Gordon Duns: "Sorting by primary key"
Next in thread: Yuk Hon Johnny Chan: "Re: Problem creating foreign keys"
Maybe reply: Roger Snowden: "Re: Problem creating foreign keys"
Reply: Mike Philippens: "Re: Problem creating foreign keys"
Reply: Yuk Hon Johnny Chan: "Re: Problem creating foreign keys"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message