Welcome!

[silvercover]

Hi,

I have 2 related forms connected to 2 joined tables. what I want to know is that how can I code to insert submitted forms in joined tables with the same auto incremented value as a primary key for main table and foreign key for joined table? as you know, upon submission there is no auto generated primary key value to be used in other table for joining purpose.

What should I do?

Thanks in advance.

[jock]

Use the mysql last id function, it will get the primary key of the last inserted record.

http://php.oregonstate.edu/manual/en/pd ... sertid.php