Multi DB Save

Hi, i'm sorry to ask this question but I'm seraching for 2 days after a solution of my problem
(I'm sorry for my english too)

Here's my probleme, i've got 2 forms and 3 table in my DB MySql 51-120.perso,
My forms are made to register some user (members) or user (responsable).

In each forms i've got 2 DB save :
- DB save into user / user
- DB save into member / responsable

I've got an auto increment on the id of the user and i would like that the id of the member or of the responsable match everytimes

for now every id is on auto increment ans so if I create a member :
user id -> 1
member id -> 1
and after i create a responsable :
user id->2
responsable id -> 1 (I would like 2 here)

I'm not sure to be very clear ...

Hi Groris,

Leave the tables ids to auto-increment, that's important. If you want to link the two tables then add a second column that will include the id of the corresponding record in the other table.

If you are registering the users in Joomla! then I suggest that you use their Joomla! User IDs to identify them.

Bob

How can i do that ?
I use the joomla form for the user in fact but i need other information so i've got 2 form when registerd and those 2 forms use 3 other db table "utilisateur", "membre" and "responsable" because some field are commun between "membre" and "responsable

I've siplified my DB i put redondant field as name, and adress so now i've 2 DB for 2 Forms and it works🙂

Thx for you answerd

Groris