Sorry, I'm becoming a familiar face to this forum now. Hate to keep bothering, but I am a total n00b!.
Ok so I have a financial website which has a very detailed (over 100 form fields) application form on it.
What I am struggling with at the moment is the following:
I enter my email address and a password on page 1 (for retrieval purposes). This then redirects to the first of four form pages. On the first page (personal details) the form data gets inserted intoa table (secure_loan), they then get redirected to the second page.
My question is (for design purposes):
Is it possible to then update the same table (as the first page) with the form data from the second page, or would it be far easier to have a seperate table, and for the retrieval (admin pages) just have sql statements linking tables).
I am very familiar with Oracle, but not so with MySQL. So I have a loan_id column in the first table, how do I link that to the loan_id on the second table. Do I have to manually create a foreign key or something?
Sorry, lots of questions, but any advice would be appreciated.