Hi gurus -

I have multiple forms that need filling in and submitting (via the web) to a mysql database,using perl -

If I have two tables (say 'user_details' and 'info') - and they fill a form in with name,address,course,info -

How do I get both tables updated with the relevant information - eg name and address -> into user_details
course and info -> into info

and keep them in sync ?

I could you one table per form - but this does not seem very 'relational' !

Any help/pointers greatly appreciated (don't worry RDMS book is on order ;-)