Forum Discussion

ChrisSwirtz's avatar
ChrisSwirtz
Qrew Cadet
4 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 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
------------------------------