I have a parent table :
Key : MemberId
Foreign Key : SponserId, UplineMemberId of MemberId at TMPARENT.
Error at creation :
There are no primary or candidate keys in the referenced table 'TMPARENT' that match the referencing column list in the foreign key 'FK_TMCHILD_SponserId'. Could not create constraint. See previous errors.
What is the problem ?