Forum Discussion

DianeSinawi1's avatar
DianeSinawi1
Qrew Member
4 years ago

Can I let users add values from child table into embedded report in parent table form?

I have a parent table "Controls" used for SOC 2 compliance. I have a child table "Evidences" listing all evidences that are used during audits, with a special numbering system. Each Control can have m...
Relationships
DianeSinawi1's avatar
DianeSinawi1
Qrew Member
4 years ago
Evidences only have the one parent table of Controls, but each evidence can be assigned to multiple Control records.

------------------------------
Diane Sinawi
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
You will need to have a new structure for your relationships.
You are saying that One Control has Many Evidences.
But also one Evidence can be used on many Controls.

So you need to have a middle join table of "Control Evidences".

Then when you go to add an "Evidence" to a control, you will actually be adding a Control Evidence record.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • DianeSinawi1's avatar
    DianeSinawi1
    Qrew Member
    4 years ago
    If I use a many-to-many relationship, will my main Control form still be in the Control table, or do I need to move it to the join table?

    ------------------------------
    Diane Sinawi
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      The Control record stays the same but the embedded child report of Control Evidence records will be records from the join table.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • DianeSinawi1's avatar
        DianeSinawi1
        Qrew Member
        4 years ago
        Thank you for your help. I was hesitant to use many-to-many relationship because everything I read said it was complicated and to avoid if possible. But I watched a tutorial, and I was able to put it together quickly and easily, and it works like a dream.

        It's an added bonus that we now also have associated Controls listed in each Evidence form, so I think this will make reporting on both easier overall.

        Thank you!!

        ------------------------------
        Diane Sinawi
        ------------------------------