Insert in to multiple tables - auto increment

[ade234uk]

I have usually created my own random id for users records and inserted this across two or more tables to use as a user_id when submitting from a form.

Of course the proper way to do this, would be to use auto increment.

However I am not sure, when inserting to multiple tables, how I could ensure the auto increment are kept in sync when a new record is inserted in to, two or more tables.

[laserlight]

I would use one table as the "base" with auto increment, then get the auto incremented id right after insertion and insert it into the other tables.

[ade234uk]

I will give this method a go.
Thank you very much.