Forum Discussion
Don beat me to it, but here is an example with more detail
var text OrderURL =
URLRoot() & "db/" & [_DBID_ORDERS] & "?a=dr&rid=" & [Related Order];
var text PurchaseOrderURL =
URLRoot() & "db/" & [_DBID_PURCHASE_ORDERS] & "?a=dr&rid=" & [Related Purchase Order];
var text URLONE =
"<a href=" & $OrderURL & ">" & [Order Identifier] & "</a>";
var text URLTWO =
"<a href=" & $PurchaseOrderURL & ">" & [PO Identifier] & "</a>";
List("<br>",
If([Related Order]>0, $URLONE),
If([Related Purchase Order]>0, $URLTWO))
In the example above, the links will only show if there is indeed a link to go to. So there might be two links showing or one link showing or maybe no link showing if for some reason, the record is a complete orphan.
Megan,
Mark's is better. The logic to hide an invalid link will serve you well.
See if you get Magic Button's for some very good examples.