Wan to pass the values from two diffrent table into one table

[Swati]

Hello everyone,

I want to select the person name from one table and course from the other table in the form. When I assign the course to a person it should pass the person id and course id into another table. I don't know how to do it.

I will be great if someone can help me.

Thanks
Swati

 

[JohnLee]

Hi Swati,

What's the purpose of putting both bits of information into another table, from the information you've supplied, it sounds like you've created your courses table, employee table and the link table, which brings the information from both tables together [I'm assuming you have a parent form and a sub form].

I think all you need to do now is create a query containing these 3 tables to produce the information in the way you want.

John

 

[Swati]

Hi John,

I have three tables.
1) Personal_Details
2) Course_Master
3) Enrolment

I am trying to select the name from personal_ details, course name from course_master and passing their primary key to the enrolment table which I will further use for attendance.

Main idea is to assign multiple courses to a single person.

I have tried to use copy function but I cannot think of any other way.

Thanks a lot

Swati