Re: creating skips

Hey Tim: > I have to say that for referential integrity within the database I would > only submit upon receiving ALL the information. Carrry information from one > page to another inn session variables and apply the insert at the very end. > ... > an uncompleted questionnaire is possibly worse than useless as it may > adversely skew the results Excellent point. But, you can do both, save the data in the main table as users go along and only study the results from finshed questionaires. When you want to study the results of the survey, design your query to only analyze data from fully completed surveys. One way to do it is have a boolean field in each reacord that indicates if the survey was finished or not. Doing it this way will give you the best efficiency and results. It even allows you to realize how many people stop the survey in the middle and where they most frequently stopped. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409