Hi all, i have a problem with updating the junction table. I am doing this access project after learning for 2 weeks so pardon me if what the question im asking is really simple.
Firstly i have 3 Tables: customers, projects and contracts with contracts being the junction table. I have this form allows users to add/edit the customer data and another tab to edit the project data of the user. If i were to create a new customer and projects using the form, only customer and projects table will be updated.
How can i make it update my junction table as well?
The link to my database:
yousendit.com/download/THE0eFlUVEhFd2V 4dnc9PQ
Firstly i have 3 Tables: customers, projects and contracts with contracts being the junction table. I have this form allows users to add/edit the customer data and another tab to edit the project data of the user. If i were to create a new customer and projects using the form, only customer and projects table will be updated.
How can i make it update my junction table as well?
The link to my database:
yousendit.com/download/THE0eFlUVEhFd2V 4dnc9PQ