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...

MarkShnier__You

Qrew Legend

3 years ago

If the Shipment # 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
Qrew Cadet
3 years ago
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
  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:])