Solved Update table not directly related (1 Viewer)

Krayna

Member
Local time
Today, 21:58
Joined
Sep 24, 2020
Messages
452
I am trying to write a query to update a table which is not directly related to another but not sure how to go about it. I have a query which joins some of the tables (qrySessionWeekdayTimes) between the two but not sure how to extend/base update query on this.
The query should update jtblSessionWeekdayStudent with all students in jtblStudentSession - linked via fldSessionID.
Would appreciate any help for this please...
 

Attachments

  • SessionTest13.accdb
    2.1 MB · Views: 65

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:58
Joined
May 7, 2009
Messages
13,702
i don't think you need to update any table when you can do it in a Query.
see Query2
 

Attachments

  • SessionTest13.accdb
    2.1 MB · Views: 71

Krayna

Member
Local time
Today, 21:58
Joined
Sep 24, 2020
Messages
452
True. However since we added this table after populating jtblStudentSession, I would like to append/update the jtblSessionWeekdayStudent with related records. (I imagine your query is for viewing only.)

In actual design I would like to automatically add all students in jtblStudentSession to each session scheduled and offer option to remove students who do not attend a particular session.
 

Krayna

Member
Local time
Today, 21:58
Joined
Sep 24, 2020
Messages
452
Just to say I've resolved this issue:)

Used a straightforward append query based on a query bringing the tables together (although there were a number of links btwn the two...)

Thanks for pointing me in the right direction @arnelgp :)
 

Users who are viewing this thread

Top Bottom