复制另一列中的查找字段值 - Access Web App [英] Copy lookup field value in another column - Access Web App

问题描述

大家好，

我的访问应用程序中的表格来自SharePoint列表。 SharePoint列表有一个名为ProjectId的数字字段，用于在我的访问应用程序中的多个表中查找。但是，并非所有查询都在此查找字段上工作。但是，如果我
使用数字字段而不是查询我的查询它工作正常。因此，我决定在插入记录后立即在数字字段中复制查找值。

但是，复制的值不正确。以下是我的实施。请帮忙。

我想在创建记录后立即在ProjectNumber字段中复制ProjectId。我在Insert上添加了以下查询。

但是，在ProjectNumber字段中复制的数据是不同的。它正在从查找表列表中复制ID字段。下面是主表的结果和快照：

任何帮助表示赞赏。提前致谢。

问候，

Monali

---

Monali

解决方案

嗨Monali，

你的问题是由那造成的查找字段的值是索引而不是实际值。

为了满足您的要求，您可以在表中找到用于查找的实际值字段，然后在需要时设置值。

下图显示了一个简单的演示。 UserId是UImage中的查找字段，它绑定到tblUser.id。

最好的问候，

Edward

Hi All,

I have table in my access app that is coming from SharePoint list. The SharePoint list has a number field called ProjectId which is used as lookup in multiple tables in my access app. However not all queries are working on this lookup field. However if I use a number field instead of lookup my query it works fine. Hence I decided to copy the Lookup value in number field as soon as record is inserted.

However, the the value copied is not correct. Below is my implementation. Please help.

I want to copy ProjectId in ProjectNumber field as soon as record is created. I have added the below query on Insert.

However, the data that is copied in the ProjectNumber field is different. It is copying the ID field from the lookup table list. Below is the result and snap shot of master table:

Any help appreciated. Thanks in advance.

Regards,

Monali

---

Monali

解决方案

Hi Monali,

Your issue was caused by that value of lookup field is index instead of the real value.

To achieve your requirement, you could find the real value in the table which you used for lookup field, and then set the value when you needed.

The image below shows a simple demo. The UserId is a lookup field in UImage, and it is binding to tblUser.id.

Best Regards,

Edward

这篇关于复制另一列中的查找字段值 - Access Web App的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！