OK, new day and new energy ....
The Action looks pretty good but you will also need to log the name of he table being logged. For example "Orders".
The main direction that you want to access the logs from is from the Record being logged, I will pretend it is the Orders table where you want easy access to the Logs of the changes.
The Low Tech way is to make a Report Link field. A Report Link field just runs a report while sitting on a form and adds an extra filter to the report where a value in a specific field on the Main record matches the the value in a specific field on the target table.
So on the orders table make a field called link Link to Logs with a formula of "Orders-" & [Record ID#].
On the Log file make a field with the formula
& "-" & [Record ID# of table being Logged]
so for example they would both calculate to Orders-123 for the record ID# 123 on the orders table.
Then put that Report Link field on the Order record form. You can choose to actually list the log records as an embedded report on the Orders form or just have a link and the user can choose to see the audit logs if they wish.
.....................
Now if you do want to link in the opposite direction, then you will need a formula like this as a formula Rich text field
var text Words = ToText([Record ID of Changed Record]);
var text DBID = Case(
,
"CO", [_DBID_CONTRACTS],
"CCI",[_DBID_CUSTOMER_CONTRACT_ITEMS],
"ICI", [_DBID_CONTRACT_ITEMS],
"PCE",[_DBID_PROJECT_PHASE_COST_ESTIMATES],
"CI", [_DBID_COST_ITEMS],
"T", [_DBID_LABOR_TAKEOFFS],
"P", [_DBID_PROJECTS],
"CIE", [_DBID_CONTRACT_INCLUSIONS___EXCLUSIONS],
"CAL", [_DBID_CONTRACT_APPROVAL_LOG]);
var text URL = URLRoot() & "db/" & $DBID & "?a=dr&rid=" &ToText([Record ID of Changed Record]);
"<a href=" & $URL & ">" & $Words & "</a>"
