amitfalana
Member
Dears,
I have been struggling with the below for quite some time. Hope I am building it correctly!
I am building a system wherein certain registered users (say U1) will submit data (Table: Submission, with a few child tables with FK to SubmissionID) and certain other users (say U2) will review data and provide comments (Table: Comments) against the submissions. (So, U1 will enter data for their submissions; U2 will see all the list of Submissions and provide comments to be stored in Comments). The Submissions to Comments is a 1-to-Many relationship. I have set different ACLs for the users.
I have managed to get the Submission part working using Fabrik List/Form/Elements (Thanks to the Fabrik team for building such a great tool!!!). Although implementing the Comments part has been a struggle. I have created a Foreign Key in Comments linking to the SubmissionID, and done a DB Join for the same.
Now when I enter a new Submission, it asks me for a Comment as well, which is not what I expected. I have tried to suppress this by using access control, etc, but have been unsuccessful.
Thus my questions:
1. Am I right to create a DB Join between Submission and Comments? If not, then how shall I manage this?
2. If yes, how do I enable adding data to only the parent table (Submission table, while it has a DB join with Comments)?
3. And, how do I enable adding data to only the child table (Comments table)?
Thanks for your support!
Regards,
Amit
I have been struggling with the below for quite some time. Hope I am building it correctly!
I am building a system wherein certain registered users (say U1) will submit data (Table: Submission, with a few child tables with FK to SubmissionID) and certain other users (say U2) will review data and provide comments (Table: Comments) against the submissions. (So, U1 will enter data for their submissions; U2 will see all the list of Submissions and provide comments to be stored in Comments). The Submissions to Comments is a 1-to-Many relationship. I have set different ACLs for the users.
I have managed to get the Submission part working using Fabrik List/Form/Elements (Thanks to the Fabrik team for building such a great tool!!!). Although implementing the Comments part has been a struggle. I have created a Foreign Key in Comments linking to the SubmissionID, and done a DB Join for the same.
Now when I enter a new Submission, it asks me for a Comment as well, which is not what I expected. I have tried to suppress this by using access control, etc, but have been unsuccessful.
Thus my questions:
1. Am I right to create a DB Join between Submission and Comments? If not, then how shall I manage this?
2. If yes, how do I enable adding data to only the parent table (Submission table, while it has a DB join with Comments)?
3. And, how do I enable adding data to only the child table (Comments table)?
Thanks for your support!
Regards,
Amit