Skip to main content
Question

How to generate a Related Report Link from one table to another

  • September 19, 2021
  • 0 replies
  • 35 views

Hello,

Currently I have a list of PROJECTS that have associated costs within them to complete.
Those are associated under a Table Called STANDARD COSTS.
There's a many to many relationships table that allows specific standard costs to be attached to each project called STANDARD ADDERS TO PROJECT.


I'm building another table called PROJECT COSTS to generate formulas for totals from the information regarding the standard costs attached to a project which is currently a report link from STANDARD ADDERS TO PROJECT and is embedded in the PROJECTS table.

Whenever I relate PROJECT COSTS to PROJECTS, and have a Many to many relationship with STANDARD ADDERS TO PROJECT with PROJECT COSTS I still can't "look up" the report link field from my PROJECTS page since there appears to be no REPORT LINK LOOK UP FIELD

Is there a way to relate the Report Link to my PROJECT COSTS table?

Thank you so much for any support in advance.


------------------------------
Anthony Wong
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You cannot look up a Report Link field.  But you can simply make a Report Link field and configure  the left and right fields that you want to match.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------