Guest_imported
New member
- Jan 1, 1970
- 0
I am currently 'databasing' a questionnaire. I've put together the database and it is now fully normalised. I've tried to use a suitable number of tables.
Basically, what I want to put together is a wizard application which takes the user through adding a questionnaire entry into the database. e.g.
step 1 - add company name/details to tblCompany - company is assigned a unique ID.
>> What code can I use to add this info to tblCompany and then move on to step 2?
step 2 - the user then inputs the company's number of employees, etc in tblCompanyDetails, along with the companyID (links to tblCompany).
>> How do I make companyID persistent? - i.e. carry from step 1 form to step 2?
**I'd be exceptionally grateful if anybody could help**
Thanks in advance.
Matt Bates
Basically, what I want to put together is a wizard application which takes the user through adding a questionnaire entry into the database. e.g.
step 1 - add company name/details to tblCompany - company is assigned a unique ID.
>> What code can I use to add this info to tblCompany and then move on to step 2?
step 2 - the user then inputs the company's number of employees, etc in tblCompanyDetails, along with the companyID (links to tblCompany).
>> How do I make companyID persistent? - i.e. carry from step 1 form to step 2?
**I'd be exceptionally grateful if anybody could help**
Thanks in advance.
Matt Bates