无法在备忘，OLE或超链接对象（Access 2007 - 外连接）上加入 [英] Cannot join on Memo, OLE, or Hyperlink Object - Access 2007 - outer joins

问题描述

我在Access 2007 ...中有2个这样的表...

 表1  -  tbEmployees详细信息
 FieldName Data类型
 PK * ID自动编号
 EmployeeID编号
第一文本
 ... ... 
 
表2  -  tbEmployeesQualification 
字段名数据类型
 PK * ID自动编号
 CV（附件）附件
资格/证书（备忘录）
技能（备忘录）
  / pre> 
 
 
我在设计阶段的关系。我试图使用外部联接从上表，因为我想附加每个员工的简历。我试过以下。 
将标识从tbEmployees Details拖动到tbEmployeesQualification。然后加入属性屏幕出现... 
 左表 - 右表 -  
 tbEmployees详细信息tbEmployeesQualification 
左栏 - 右栏
 ID资格/证书
  
我选择了选项2  - 
 
 
 
为了测试这个，我使用了Query。当我使用查询向导似乎查询显示结果，包括所有的数据从tbEmployees详细信息和所有的数据tbEmployeesQualification BUT 
 
 
 
当我使用查询设计我得到以下错误。 .. 
 无法加入备忘录，OLE或超链接对象（[tbEmployees Details] .ID = [
 tbEmployeesQualification ]。[Qualification / Certificate]）
  
错误是正确的。我知道ID有Autonumber作为数据类型和资格/证书从tbEmployeesQualification作为备忘录数据类型，因此内连接不能使用。所以我的问题是如何解决这个问题？或者可以通过使用外连接来解决，或者我需要做一些我还没有看到的东西？ 
 
 
 
感谢您提供时间回答我的问题。 
 
 
 
 EDIT  -  
我认为外键也许是答案。我刚刚在tbEmployeesQualification中添加了数据类型为ID的ID。创建一对多关系一个是tbEmployees详细信息，许多是tbEmployeesQualification。我会马上更新。
解决方案
问题是通过使用一对多关系解决的。在tbEmployees表中，我将名字放在具有数据类型Text的字段名称（PK）中。再次在tbEmployeesQualification表中，我创建了字段名FirstName，数据类型为Text。我链接到tbEmployees表（一）到tbEmployeesQualification表（很多）。这解决了这个问题。 
 
I have 2 tables like this in Access 2007...
 Table 1 - tbEmployees Details
           FieldName      Data Type
      PK   *ID            Autonumber 
           EmployeeID     Number
           First          Text
           ....           ...

 Table 2 - tbEmployeesQualification
           FieldName    Data Type
     PK   *ID           Autonumber  
           CV (attachment)  Attachment  
           Qualification / Certificate (memo box)
           Skills (memo box)
I am at design stage in relationship. I am trying to use outer join's from the above tables because I want to attached CV's for each employee. I have tried the following.
Drag the ID from tbEmployees Details onto the tbEmployeesQualification. Then the  Join Properties a screen appears... 
   Left Table  -            Right Table -
   tbEmployees Details      tbEmployeesQualification 
   Left Column -            Right Column 
   ID                       Qualification / Certificate
I have selected Option 2 - Include ALL records from .... where the join fields are equal.

To test this I have used Query. When I use Query Wizard it seems query shows results that includes all the data from tbEmployees Details and all the data tbEmployeesQualification BUT

when I use Query Design I get the following error...
Cannot join on Memo, OLE, or Hyperlink Object ([tbEmployees Details].ID=[     
tbEmployeesQualification].[Qualification/Certificate])
The error is correct. I know ID has Autonumber as data type and Qualification / Certificate from tbEmployeesQualification as memo data type so therefore inner join cannot be used. So my question is how do I solve this problem? or can it be solved by using outer joins or do I need to do something else that I have not seen? 

Thanks in advance for the time to answer my question(s). 

EDIT - 
I think foreign key maybe the answer. I have just added ID with data type as Number in the tbEmployeesQualification. Create one to many relationship one is tbEmployees Details and many is tbEmployeesQualification. I will update soon.
解决方案
The problem was solved by using one-to-many relationship. In tbEmployees Table I put First Name in Field Name (PK) with data type Text. In tbEmployeesQualification table again I created Field Name FirstName with data type Text. I linked tbEmployees Table (one) to tbEmployeesQualification table (many). This solved the problem.  

                        
这篇关于无法在备忘，OLE或超链接对象（Access 2007  - 外连接）上加入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！