Can I have a formula field maintain the link properties of a relationship?

So you will need to make you own hyperlink field as a formula text field with HTML enabled.


It will be something like this

var text URLA = URLRoot() & "db/" & [_DBID_BID_CATEGORIES] 
   & "?a=dr&rid=" & [Related Bid Material Category];

var text WordsA = [other table field name like claim name or number];

var text LinkA = "<a href=" & $URLA & ">" & $WordsA & "</a>";


var text URLB = URLRoot() & "db/" & [_DBID_BID_other table name here] 
   & "?a=dr&rid=" & [Related other table ];

var text WordsB = [other table field name like Project name or number];

var text LinkB = "<a href=" & $URLB & ">" & $WordsB & "</a>";

if(
[related claim] > 0, $LinkA,
[related project]  > 0, $LinkB)