Discussions

Expand all | Collapse all

Showing parent record report on child record

  • 1.  Showing parent record report on child record

    Posted 01-09-2020 12:21
    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
    ------------------------------


  • 2.  RE: Showing parent record report on child record

    Posted 01-09-2020 13:05
    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
    ------------------------------



  • 3.  RE: Showing parent record report on child record

    Posted 01-09-2020 15:43
    The field I am trying to show is a file attachment

    ------------------------------
    Russell Beaubien
    ------------------------------



  • 4.  RE: Showing parent record report on child record

    Posted 01-09-2020 16:06
    Edited by Mark Shnier (YQC) 01-10-2020 08:47
    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
    ------------------------------



  • 5.  RE: Showing parent record report on child record

    Posted 01-10-2020 08:36
    Thank you that worked perfectly.

    ------------------------------
    Russell Beaubien
    ------------------------------