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

Question

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. That defaults to showing the related records Record ID, how do I get it to show a different Field in the related record? Or is there a URL formula perhaps to return the field I am looking for in the related record to show on the Parent Record? I want the [Shipment #] field to show on the Parent Record.

------------------------------
Chris Swirtz
------------------------------

markshnier__you · Answer

If the Shipment #&nbsp;is ​Unique and that is a lookup field from Purchasing down to Shipping Logs, then you can make a new Report Link field and configure the the Field Properties to have the Shipment ID# on the left (from the Purchasing table) and the Shipping ID# from the Shipping Logs table on the right.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

chrisswirtz · Answer

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 · Answer

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 · Answer

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 · Answer

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.&nbsp; But the formula will be a multi-select text field type so make a formula field called [Shipment ID#] with a formula of&nbsp;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------------------------------

Forum Discussion

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

6 Replies