>Why is CID not found? Any idea?
You have to write
INSERT INTO course (cid, c_title, semester, year)
VALUES (thisform.page1.cid.value, thisform.page1.c_title.value, thisform.page1.semester.value, thisform.page1.year.value)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison