for my application I have created a database containing a table where my clients data is stored before they are allowed to use the website.
When they are allowed, the info on this table has to be transferred to 3 different tables, using the insert...select-statement. Doing this I don't want to transfer the ID from this table into the others ; instead, I want to insert the data into the first table, with its own ID, and then use this ID as a foreign key into the other 2 tables.
Has anyone an idea how to construct this or these query's ?
Thank you for spending time on this !