Select amongst multiple parent with Click

Question

I've a children table "Task" whose parent is from table A-"Senior Staff Project" or table B-"Junior Staff Project"
In child table "task" , a very simple Rich Text say "P.name" formula determines the parent child with

if[related senior staff project&gt;0,"Related Staff Project", "Junior Staff Project")

But "rich text" formula "p.name" is not clickable , nor does it related to the original project&nbsp;
How can I achieve so ?&nbsp;
------------------------------Prashant Maheshwari------------------------------

markshnier__you · Answer

You will need to build you own Rich text hyperlink field

The generic format is

Hyperlink Example

var text Words = ....;

var text URL = URLRoot() & "db/" & [_DBID_PATIENTS] & "?a=dr&rid=" & [Related Patient];

// this last part is always the same

"<a href=" & $URL & ">" & $Words & "</a>"

so for the words you will have an IF statement to calculate the correct name.

Then, similarly you calculate the correct URL to go to. You can post back if you have trouble calculating the URL syntax.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

prashantmaheshw · Answer

Got it ! thanks you Mark for quick reply !------------------------------Prashant Maheshwari------------------------------

Forum Discussion

Select amongst multiple parent with Click

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking

How to consolidate multiple rows into one