Insert userid into other tables when making new user

I have a table called “allusers” which stores userid, username, password and level. I have an insert form to make new user. Now I would like, upon inserting a new user, two other tables to make a new record and store the userid in them as well.
Can this be done? If so, than how do I go about doing that?