问题描述
大家好;
我有一个包含名为CPUServicetag（序列号）的文本框控件的表单。我的用户手动输入CPUServicetag。我的问题是这个......我如何在一个单独的文本框控件中创建一个表达式，在控件源中将手动输入的CPUServicetag交叉引用一个名为RMA的表，其中包含两个字段：Serial_num（CPUServicetag）和RMA＃ ，并在此单独的文本框中显示控制与CPUServicetag关联的RMA＃，它与Serial_num相同。这是我以前从未处理过的，需要一些帮助
Hi All;
I have a form that contains a textbox control called CPUServicetag (Serial number). My users enter in the CPUServicetag manually. My question is this ... How do I go about creating an expression in a separate textbox control with in the control source that would cross reference the manually entered CPUServicetag to a Table called RMA which contains two fields: Serial_num (CPUServicetag) and RMA# , and display in this separate textbox control the RMA# associated to the CPUServicetag which is the same as Serial_num. This is something I have never dealt with before and need some assistance
推荐答案
我假设您将[RMA＃]字段名称改为[RMA]，并且，现在，假设Serial_num字段是字母数字。
I''ve assumed you will change your [RMA#] field name to simply [RMA], and, for now, have assumed that the Serial_num field is alpha-numeric.
这篇关于创建将交叉引用表的文本框控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！