Create a module/macro to update a junction table in MS Access

[DDTiff]

Hello Everyone,

I'm new to the forum. It's nice to meet you all.

Can anyone help me with the junction table problem, which I described below? I deeply appreciate your time and effort.

I have three tables in my DB(Task, Resource, and Assignment), and I combined these three tables to create a brand new one named JT(stands for junction table).

However, I have a hard time figuring out how to create a module/macro to update the JT table when one or all of the three tables change(s).

I like to use the update module/macro to create a taskbar button for MS Access Window (this part I know how to do).

I have MS Access 2000. Thank you for your help.


Diem