自动编号未链接 [英] Auto Number Not Linking

问题描述

好的，我有3个表，一个有客户ID（PK）号和关于客户的信息（客户表）。另一个带有订单号（PK）的表，带有支付信息等，由客户ID（FK）链接的bieng（orderinfo表）。最后一张表，其中包含订单号和构成订单的说明/项目（订单表）。我是这样做的，所以每个订单号我可以有更多的1项。


Heres有点看起来像：

Ok, I have 3 tables, one with a customer ID(PK) number and info about the customer(customer table). Another table with an order number(PK), with payment info and such, bieng linked by the customer id(FK),(orderinfo table). And a final table with the order number and the description/items that make up the order(order table). I did it this way so i can have more that 1 item per order number.

Heres kinda what it looks like:

展开 | 选择 | Wrap | 行号

推荐答案

从技术上讲，子表单不被视为开放表单，而是主表单上的控件，不能像这样引用。


您必须将setfocus设置为子窗体，然后执行acnewrec，并再次将焦点设置回主窗体。这是一种方法。将此代码放在按钮的On_Click事件中。尝试一下，让我知道它是否有效

Technically, a subform isn''t considered an open form, but is a control on the main form, and can''t be referenced as this.

You''ll have to setfocus to the subform, then perform the acnewrec, and set focus back to the main form again. This is one way to do it. Put this code in the On_Click event of a button. Try it and let me knwo if it works

展开 | 选择 | Wrap | 行号

好的，我试过代码，但几乎没有任何反应。

Ok, I tried the code, but pretty much nothing happens.

您的表单基于什么查询？

what are the queries that you are basing your forms on?

这篇关于自动编号未链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！