Relationship error, enforce referential integrity, cascade updates

[allright]

Hi there,
I have 3 tables with one to many relationships , when i am trying to create another relation between prodlev2 and prodlev3 tables and "prodlev1" as a common field , i am getting this error message "No unique index found for the referenced field of the primary table". Could you help me with this.
Note all tables are setup with Enforce Referential Integrity and cascade updates and deletes

Product1 product2 product3 -->(tables)
prodlev1 prodlev2 prodlev3
prodlev1 prodlev2
prodlev1

(Product1, product2)prodlev1 one to many prodlev1
(Product2, product3)prodlev2 one to many prodlev2
(product2, product3)trying to do prodlev1 one to many to prodlev1

thanx any suggestion will be appreciated

 

[traingamer]

If prodlev2 is the primary key for product2 then there is no need to link prodlev1 between product2 and product3.

AND

including the field prodlev1 in product3 is not neccessary. It already has enough references.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill