通过Subform添加记录 [英] Adding records through Subform

问题描述

我对自己的所有sqls和子表单都有点混淆了。我对关系数据库有点新意。


我有一个数据库，专门用于预订学生到我们临终关怀医院的课程。它基于三个主要表格。 [tblCourselist]，[tblStudentinformation]和一个链接这些[tbleLINKStudent_Course]的表。


我有一个基于[tblStudentinformation]的表单[frmStudentCourseRecord]，带有一个基于SQL查询的子表单我在下面列出了。这显示了学生之前注册过或已经注册的课程的详细信息：

展开 | 选择 | 换行 | 行号

解决方案

您（意外）在访问文章部分中发布了此问题。这不是一篇文章。

我将它移到主要的Access问题论坛。


ADMIN。

< blockquote>我不太热衷于使用这样的表单，但是（在表单上过滤示例。 ）可以帮助您了解我的需求。

PS发布代码时，简单的方法是在一个块中选择所有代码，然后单击哈希（＃）按钮。这将为您添加代码标签：）

感谢您的支持。我看了一下代码，但需要一些时间来理解它。


谢谢

I''ve got myself a bit mixed up with all my sqls and subforms. I am a bit new to relationship databases.

I have a database designed for booking students on to courses run at our hospice. It is based on three main tables. [tblCourselist], [tblStudentinformation] and a table to link these [tbleLINKStudent_Course].

I have a form [frmStudentCourseRecord] based on [tblStudentinformation] with a subform based on an SQL query which i have listed below. This shows the details of the course(s) the student is registered on or have been on previously:

Expand|Select|Wrap|Line Numbers

解决方案

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I''m moving this to the main Access questions forum.

ADMIN.

I''m not too hot on using forms like this, but (Example Filtering on a Form.) may help you from what I understand of your needs.
PS when posting code, the easy way to do it is to select all your code in a chunk, then click on the hash (#) button. This will add the code tags for you :)

Thanks for that. I have had a look at the code but will need some time to understand it.

Thanks

这篇关于通过Subform添加记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！