Forum Discussion

RussellBeaubien's avatar
RussellBeaubien
Qrew Cadet
6 years ago

Showing parent record report on child record

In Table-to-Table Relationships can I add a lookup field with the field type "Report Link"
In the parent table there is a default field that is field type "Report link" but i need it on the child table.

------------------------------
Russell Beaubien
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    You cannot look up a Report Link field, but you can certainly create one on the child record.  You do not need to have a relationships to have a Report Link field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • RussellBeaubien's avatar
      RussellBeaubien
      Qrew Cadet
      6 years ago
      The field I am trying to show is a file attachment

      ------------------------------
      Russell Beaubien
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        np,
        If you make a field with a formula like this on the Parent record

        URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0"

        and replace 99 with the field ID# that holds the file attachment, then you can look up that field down to the child and it will work as a link to open the file.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------