PaulPeterson
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Help needed with Many to Many relationship
As Ivan pointed out earlier, the app is in need of some significant refactoring. The installation table is already in serious need of normalization and I would like to avoid adding more design issues. There are currently 13 services in the verification table. I need to send back the results from 2 checkboxes and 4 text fields for the services the customer is using along with the last modified by user and last modified on timestamp. I would greatly appreciate your suggestions for sending this data back to the parent table. ------------------------------ Paul ------------------------------0Views0likes3CommentsRe: Help needed with Many to Many relationship
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 ------------------------------0Views0likes14CommentsHelp 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 verification table will use the data from the installation table and add verification details and return the data to the installation table. I currently have three tables to accomplish this, the installation table, verification table and a bridge table. The current relationships are: The installation is the parent for the verification table, the verification table is the parent for the bridge table and the bridge is a parent for the installation table. My thinking on these relationships is the installation table sends data to the verification, the verification table sends the verification data to the installation table via the bridge. I can get data to the verification table and to the bridge, but not back to the installation table. I have two questions. First, is this logic sound? The second question is a little more cloudy. Another team member added a relationship with the verification table being parent for the installation table thinking we do not need the bridge table. Would this relationship in any way prevent the data flow from the bridge to the master or would if cause any other issues. There is one additional problem. The key field in the Installation table may not exist in the verification. The key in the installation table is the project number, but not everything being verified will be associated with a project number. I apologize for the lengthy post, I wanted to provide as much information as possible. ------------------------------ Paul ------------------------------4Views0likes16Comments