Want to insert values from one table to another

[Swati]

Hello everyone,

I am new to this forum. I have three tables

1) Personal Details
2) Course Master
3) Enrolmet

I want to pass the personal_ID to the and Course_Id to the enrolment table.

The problem is the I want to search the person by using forms and then assignt the course to that person. That person can be assigend multiple courses. I don't know how can I do this...

I will be great if someone can help me.

Thanks
Swati

 

[EraserveAP]

You could tie a combo box to "Personal Details" and another to "Course Master"
You could then add a button that when Clicked used DAO to Append "personal_ID" and the "Course_Id" into the "enrolment" table.