在源表中找不到表单需求字段 [英] Form needs field not found in source table

问题描述

我有3个名为INVESTIGATOR的表，LINKJOIN  
和  PROJECT。  我在INVESTIGATOR&& ;;& ;; LINK和PROJECT & LINK表，从而创建M：M关系（INVESTIGATOR ：PROJECT）。

I have 3 tables named INVESTIGATOR, LINKJOIN  and  PROJECT.  I have established 1:M relationships between INVESTIGATOR & LINK and PROJECT & LINK tables, thus creating a M:M relationship (INVESTIGATOR : PROJECT).

 

我需要包括一个字段“ LastName”来自LINKJOIN表中的INVESTIGATOR表，用于按表格中的LastName（排序方式）进行排序。 

< span style ="font-size：small; font-family：Times New Roman"> 

我知道我可以轻松地使用查询作为我的表单的来源，即排序（排序）姓氏。  ;
然而，正如我所知，我必须保持LINKJOIN表作为我的表格来源，以满足允许我添加新调查员的NOT IN LIST事件。

I am aware I could easily use a query as the source for my form that is to sort (Order by) the last name.  However, as best I can tell, I must maintain the LINKJOIN table as my source of my form to satisfy a NOT IN LIST event that allows me to add new investigators.

 

简单地说;我需要按字母顺序排列每个项目附属的调查员列表。 
我想向我们订购，但我没有在此LINK表中使用姓氏字段。 
来自INVESTIGATOR表的LINK表中的外键（InvestigatorID）使用SQL语句来显示调查员名称。 
语句代码为：

Simply put; I have a need to alphabetize a list of Investigators affiliated to each project.  I would like to us Order by, but I don’t have the last name field in this LINK table.  The foreign key (InvestigatorID) in the LINK table from the INVESTIGATOR table uses an SQL statement to show the Investigator name.  The statement code is:

SELECT tbl_Investigator.InvestigatorID，tbl_Investigator.FirstName& " " &安培; [LastName] AS [PI Name] FROM tbl_Investigator ORDER BY LastName;

 

任何建议都将受到赞赏。

 

谢谢，

Bill

推荐答案

如果您需要表格要创建新的调查员，它应该基于INVESTIGATOR表而不是LINKJOIN表。

If you need a form to create new investigators it should be based on the INVESTIGATOR table and not on the LINKJOIN table.

这篇关于在源表中找不到表单需求字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！