使用access来管理变更控制记录。表管理帮助 [英] Using acces to manage change control records. Table management help
问题描述
大家好，
我是新来的，我正在寻找一些方向，我有想法，但我很难将它付诸实践。任何帮助将不胜感激。
我已经设置了三张桌子。
表一
这包含20个字段。这些数据被上传到宏访问的宏访问。
此表包含来自我们的suplliers的更改记录中的信息。它有一个唯一的标识符，ocp（更改编号）和更改的详细信息。我只对其中的大约5个领域感兴趣。
表2包含2个字段。 OCP号码以及邮局所有者，这是一个列出名称的下拉表，即我的名字。
表3包含7个字段。 OCP号码和邮局需要执行的所有操作。例如，除了变更，沟通，行动和审查。所有这些领域都需要由POL工作人员完成，除了OCP编号外，还需要手动填充。
我用OCP编号链接了所有三个表格。
OCP号码通过宏同时上传到所有3个表格。
我接下来进入报告并创建一个显示所有字段的报告我需要查看3个表，但是这里没有字段。
我想完成POL操作以显示我们已接受哪些更改被拒绝等，但是没有记录，分开从我的第一张桌子？
我做错了什么，我真的应该这样做更容易吗？任何建议都很受欢迎。我之前使用过数据库，但这是我想要构建的第一个数据库。我可以提前提供所需的任何数据。
Hi all,
I am new to this and am looking for some direction I have the ideas, but am having trouble putting it into practice. Any help would be greatly appreciated.
I have set up three tables.
Table one
this contains 20 fields. This data is uploaded to access by a macro in access from excel.
This table contains the information from the change record from our suplliers. It has a unique identifier, the ocp (Change number) and details from the change. I am only really interested in around 5 of these fields.
Table 2 contains 2 fields. The OCP number and also the Post Office owner, which is a drop down table listing names, i.e my name.
Table 3 contains 7 fields. The OCP number and all action Post Office need to carry out. for example excepting the change, communicating, actioning and reviewing. All of these fields need to be completed by the POL staff and apart from the OCP number are manually populated.
I have linked all three tables by the OCP number.
The OCP number is uploaded via the macro to all 3 tables at the same time.
I next went into reports and created a report showing the fields from all 3 tables that I needed to view, but this contains no fields.
I want to complete the POL actions to show which changes we have accepted rejected etc, but there are no records, apart from in my first table?
What have I done wrong and should I actually be doing this an easier way? any suggestions greatly received. I have used databases before but this is the first one I am trying to build. I can supply any data required thank you in advance.
推荐答案
BTW我正在使用Access 2003和microsft excel 2003.我将单词doc转换为excel，这个上传通过宏来访问，我只使用这些数据中的某些字段。
BTW I am using access 2003 and microsft excel 2003. I convert the word doc to excel, and this uploaded by a macro to Access, i only use certain fields from this data.
基本上我认为你只需要从导入的表开始将连接更改为左连接。这将显示导入表中的所有记录，并且只显示其他两个匹配表中的记录。
Essentially I think you just need to change your joins to left joins starting with the imported tables. This will show all records in the imported table and only those records from the other two tables that are matching.
基本上我认为你只是需要从导入的表开始将连接更改为左连接。这将显示导入表中的所有记录，并仅显示其他两个匹配表中的记录。
Essentially I think you just need to change your joins to left joins starting with the imported tables. This will show all records in the imported table and only those records from the other two tables that are matching.
好的，请试试这个谢谢。
Ok will give this a try thank you.
这篇关于使用access来管理变更控制记录。表管理帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
