You don't need any relationship. Just create a script 'LogFile'
* Go To Layout [LOG]
* New Record
* Set Field [ logFile:contentField_containingWhatHapppened ; Get( Scriptparameter ) ]
* Go To Layout [Original]
This script is called from startup script and the other scripts that do important things. When calling the LogFile script you pass via script parameter everything important you want to be logged.
I really wish I wasn't this dumb, but I understand everything except:
Set Field [ WhatHappened ; Get( Scriptparameter ) ].
I found the Set Field command, but do not understand what to put in the "WhatHappened" section or if I need to put anything in the "Scriptparameter" space. I am embarrassed to admit that I am very illiterate when it comes to programming speak.
Can you "dumb" it down for me?
In the log table there is a field 'content' for the things you want to log. You call the log script with the additional ScriptParameter:
* "Login of User " & Get( AcountName )
and this scriptstep creates the log information
* Set Field ( log::content ; Get( Scriptparameter ))
After Joe logged in you find in field log::content: "Login of User Joe".
For more explanations about script parameters see here.
Thanks for your patience. It worked out great.