问卷数据库 [英] Questionaire database

问题描述

为每条新记录显示问卷的空白列表的最佳方法是什么。并且当选中适用的是/否字段时，仅回答适用的问题的人。那时我想把这些答案写进历史表中，保留所有的答案？关于如何完成这个结构的任何建议？

What is the best way to display a blank list of questionaire for every new record. And the person to answer only the applicable questions when an Applicable Yes/No field is checked. I am thinking then to apprend those answers to the historical table where all the answers are kept? Any advice on how to get this structure done?

推荐答案

Kaylen83，


从概念上讲，你要建立一个未绑定的表格，包括文本框（或响应字段或复选框 - 您收集的任何类型的数据），并根据Y / ​​N复选框的值（您没有提到如何设置该复选框），禁用一些控制。然后，当用户完成调查问卷后，他们会点击一个提交按钮，将记录附加到所需的表格。


您要问的内容中包含许多活动部分。这可以做到，但在我们提供详细信息之前，您必须向我们提供更多信息。


请查看此主题：如何提出好问题并向我们提供有关您请求的更多详细信息。

Kaylen83,

Conceptually, you would build an unbound form that includes text boxes (or response fields or check boxes--whatever types of data you are gathering) and based on the value of the Y/N check box (you don''t mention how that check box is set), disable some of the controls. Then when the user has complete the questionnaire, they click a submit button which appends the record to the desired table.

There are a lot of moving parts included in what you are asking. This can be done, but you will have to provide us considerably more information before we can provide specifics.

Please review this thread: How to Ask Good Questions and provide us more details about your request.

嗨Tinny，谢谢你的指导。如果控件是不属于另一个表的未绑定字段，那么如何在表中显示答案？

@twinnyfo

Hi Tinny, thank you for the guidance. How do you apprend the answers the the table if the controls are unbound fields that are not part of another table?

@twinnyfo

你会创建INSERT查询，基于表单上的控件。这可能非常复杂（取决于有多少响应）。


当然，如果你想要一个绑定表单，这是更新表的最简单方法，那么你可以控制是否以其他方式保存记录。


老实说，有点不清楚你想做什么（确切地说）以及为什么你想这样做....


但是，我愿意和你一起解决你想要做的事情。

You would create an INSERT query, based on the controls on your form. This could be quite complex (depending on how many responses there are).

Of course, if you wanted a bound form, that is the easiest way to update a table, then you could control whether a record is saved or not in other ways.

To be honest, it is a little unclear what you want to do (exactly) and why you want to do it that way....

But, I''m willing to work through a solution with you with better understanding of what you want to do.

这篇关于问卷数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！