Hi:

I have two tables

Table A has columns name, type, desciption and Table B has columns id, number, description.

I want to establish foreign key relation between both the tables. But note that there is no unique index or primary key relation for the column 'description' in both the tables. How do I establish this relationship. I am using SQL server 7.0 and when I try to do this I am getting error message.

Thanks Jay

-- Anonymous, July 27, 2000

Answers

Jay,

As far as I know, Foreign key has to defined on an existing primary key and primary key, by definition is UNIQUE So to answer your question, NO it cant be done !

Thanks, Vic

-- Anonymous, July 27, 2000