Solved Update table not directly related

[Kayleigh]

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...

 

[arnelgp]

i don't think you need to update any table when you can do it in a Query.
see Query2

 

[Kayleigh]

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.

 

[Kayleigh]

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