how to set composite key as foreign key?

hi freinds,

i want to set any composite primary key in given table as foreigen key by sql query not by enterprise manager.

suppose i have library as databse and two tables as

books(cAccnumber,ctitle,cedition)

issuedetails(cAccnumber,cMembercode,dDateofissue)

wher cAccnmuber is primary key in books and cAccnumber,cMembercode as composite primary key in issuedetails.so if i want set cAccnumber as foreign key then what will be query structure.

this is possible using enterprise manager but i want to do it by code.so help me if u have any idea.

thanks

--
Posted via http://dbforums.com