auto email filed (FirstName.SecondName@xyz.ie)

[tomgag]

Hi All,



Just trying to automate db in my company (needed for some project) and wonder if you can advise how to get the auto email fed into email column. Basically all emails are designed as FirstName.SecondName@xyz.ie I have column FirstName and SecondName in the table.

T.

[June7]

Then why bother saving to another field? Just construct the email 'on-the-fly' when needed.