Good morning to all of you...well i ve some problem in implementing relationship among two tables name mainHeads and SubHead.
MainHeads([No],CatID,HID,HeadName) // No is P.K identity SubHeads([No],CatID,HID,SHID,SubHeadName) // here No is also P.K identity
Now i want to Map HID from MainHeads to SubHeads table(1:M) but it yield me the following error.
'The Columns in table SubHeads do not match an existing Primary Key or UNIQUE constraint'
can anyone help me in this regard plz