Help needed with Many to Many relationship
I am currently struggling to get data flowing correctly. The end goal is to send data from an installation table to a verification table (basic site information and services to be verified). The veri...
Forum Discussion
Can you provide a more specific use case? I am not quite sure what the three tables are actually doing as it sounds like you are trying to automate some process vs just store data in a table.
------------------------------
Ivan Weiss
------------------------------
------------------------------
Ivan Weiss
------------------------------
In a nutshell, there are two teams that work somewhat in tangent with each other. We have a group focused on installation of products/software and another team working with verifying the services are installed and functioning. However, the verification team also works with repair and troubleshooting issues that are unrelated to installs.
The installation team has a form showing the upcoming installations. One section of the form needs to include feedback from the verification team showing that the services are in fact installed, it there were any issues, details and notes about any issues.
The verification team needs to see the services that were ordered from the installation table and update their form in the verification table. The results of that need to update the fields in the installation table.
I found part of my problem a little while ago. I have my relationships wrong. I need to have the bridge table be the child of the Installation and the verification tables. What I am not sure is how to get the info to the verification and installation tables from the bridge table.
------------------------------
Paul
------------------------------
The installation team has a form showing the upcoming installations. One section of the form needs to include feedback from the verification team showing that the services are in fact installed, it there were any issues, details and notes about any issues.
The verification team needs to see the services that were ordered from the installation table and update their form in the verification table. The results of that need to update the fields in the installation table.
I found part of my problem a little while ago. I have my relationships wrong. I need to have the bridge table be the child of the Installation and the verification tables. What I am not sure is how to get the info to the verification and installation tables from the bridge table.
------------------------------
Paul
------------------------------