Hi There,
I thought this was simple but can’t find an neat way to do it.
i have 1500 users that have a usercode. this code is stored in another table that also stores the username.
table 1 username, usercode
table 2 username, usercode (empty), otherfield1, otherfield2
i’m searching for a code that can insert the usercode from table 1 into table 2 with the username as a where clausule.
i’ve tried recordset but i just don’t really understand the way it works.
any suggestions?