Problem inserting data via Web Form

[obrienkev]

I have created a form that when submitted should insert data into a number of tables.

My problem is that all tables are linked together using ID numbers which act as primarey keys.

Eack primary key field is added as a foreign key in one table called subfund.

so basically each table is linked to another by the foreign keys in table subfund.

How do I ensure proper updating of the tables?? i.e. the user enters information in the form which might relate to a particular field in another table.

Hope this makes sense.

Any ideas??

cheers,

Kevin.

[devinemke]

do cascading INSERTs on all relavant tables. if you are using mySQL then use [man]mysql_insert_id[/man] to get the appropriate foreign key for the next INSERT.