Relating a table with an account name

[fmow]

I have a table with a list of the employees of a company, and almost each one of them has an account with certain privileges in fm. How do I associate each account with a record in the table, so a modified by field can be inputted with a Name and Surname field from the employees table?

[Brooks]

Add their account name to the table and use the get( account name ) function. Then you can use a to relationship or executesql to gather whatever info you need from the employee table.

[fmow]

Hi Brookes, many thanks again. If I am following this right, I should add another field with the account names, and then have script triggered as soon as they fill a certain form, that will do get (account name) and input the related Name and Surname in the modified by/edited by field. One problem I can think of, if I 've got it right so far that is, is script triggering and IWP. 

[Brooks]

Use auto enter calc at table level

[fmow]

Cool, thanks!