I have an ‘Operators’ table which holds users, managers etc. I am hoping to use that table to fill in an INITIAL VALUE in various tables.
This is probably the first expression I have created but it returns all email addresses in that table instead of just one from the Operators table so its getting there.
I would need also to use a similar expression to pull other information so its not just as simple as putting USEREMAIL() in the INITIAL VALUE
Select a column value from the Operators table where the email address in table Operators matches the useremail.
Can anyone help with this.