Clustered Index

[Databaseguy]

I have two tables, tblInventory and tblObsolete. Inventory is self explanatory, tblObsolete lists all of the items we carry and whether or not they are current.

tblObsolete has 4 fields:

Style
Label
Color
Obsolete

The primary key is a combo of Style,Label and Color.

tblInventory also has fields Style, Label and Color. I am trying to create a relationship between the 3 fields, but whe I do I get the error message "The columns in tblInventory do not match existing primary key or unique constraint".

There is nothing in tblInventory that does not exist in tblObsolete, and vice versa.

Am I missing something really simple ?



Tyrone Lumley
augerinn@gte.net

 

[nrugado]

Try having all of the information only one table. With a flag (Boolean 1 or 0) or Date that indicates if the item is obsolete.

 

[Databaseguy]

Dope !!!

Stupid me.

I had the one side and the many side reversed......

Tyrone Lumley
augerinn@gte.net