Megan,
Make a Formula Rich Text field. You can the build out simple or sophisticated set of links in that field. You can use some HTML to build a table, colorize or otherwise surface the two links for your Users. The Magic Buttons application from Kirk Trachy was full of great examples of how to do this.
A quick and dirty example is
var text LinkOne = URL for getting to parent one;
var text LinkTwo = URL for getting to parent two;
$LinkOne & "<br>" &
$LinkTwo
That will give you both links on two rows, in the same field.
Qrew LegendDon 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.
