Combined field for related fields?

Hi Mike, 

The way that you can accomplish this is to create a formula Richt Text field.  You would create an if statement where the condition is what determines whether the [Related Parts] will be shown or [Related Pieces].  Then, as far as I know, you would need to create an anchor tag to create the link.  The following is an example:


var text displayValue = if([Condition] = true, [Related Parts Proxy], [Related Pieces Proxy]);
var number recordID = if([Same Condition as above] = true, [Related Parts], [Related Pieces]);
var text tableID = if([Same Condition as above] = true, [_DBID_Parts], [_DBID_Pieces]);
var text URL = URLRoot() & "db/" & $tableID & "?a=dr&rid=" & $recordID;

"<a href='" & $URL & "'>" & $displayValue & "</a>"

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------