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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Does an evidence only have one parent?  ie, Once an evidence is used on a particular parent can it be used again on a different parent?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • 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
        ------------------------------