I have 2 tables related to users:
'users' this contains all the commonly used information like username, password, etc.
'user_details' which contains other details like location, dob, forename, etc.
What I want to happen is when a user registers and has their details inserted into users a record is automatically created within user_details.
Is this possible without having to create a separate queries for the user table and user_details table?