c_skyscraper 0 Newbie Poster

hi guys,

I have one table:

exams(e_no integer primary key,e_name text);

now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no

questions(q_no,e_no,questions text);

so i would like to make q_no and e_no both act as primary key or combinational key.

the aim is to always insist that there will be unique question belong to single exam.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.