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 ;-)
cheers
Rab