Forum Discussion

Qrew Cadet

3 years ago

Showing a different Link Field on the Parent Record than the Record ID for the Report Link in a Relationship

Currently I have a relationship between my Purchasing table and Shipping Log table where one Purchase has many Shipping Logs and I have the Report Link set to show a link to the record versus the list...

Qrew Cadet

The Shipping # is a unique number but it originates in the Shipping Log (Child Table) so I need a way to have it show in the related Purchasing Table record (Parent table)

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

Is there only one child shipping log per Parent Purchasing? Is The Shipping Log# a numeric or text field type?

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

ChrisSwirtz
Qrew Cadet
3 years ago
Yes, there is only one Shipping Log Child per Purchasing Parent. The [Shipment #] is actually a text formula field listing the actual number with the Trucking Company ID code at the end.

List("",(ToText([SN#])),[Contact - Code:])
- MarkShnier__You
  Qrew Legend
  3 years ago
  OK, then you can make a Summary field on the relationship of type Combined Text Summary field. That will float up the text of the Shipment ID to the Parent Record. But the formula will be a multi-select text field type so make a formula field called [Shipment ID#] with a formula of
  
  ToText([Combined Text Shipment ID#])
  
  The use that in your Report link field configuration on the left side.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - ChrisSwirtz
    Qrew Cadet
    3 years ago
    Perfect, thank you!