Select amongst multiple parent with Click
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou 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
------------------------------
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
------------------------------
- Got it ! thanks you Mark for quick reply !
------------------------------
Prashant Maheshwari
------------------------------
