如何链接两个子表单导致表单不停闪烁？ [英] How to link two subforms results in non-stop flickering of the form?
问题描述
您好，
我一直试图解决这个问题一段时间，似乎无法在任何地方找到解决方案。
我有具有以下关系设置的数据库：A）具有链接到表LineItems的字段AssetID（AutoNumber）的合同表（一对多关系）。 B）LineItems表，其中字段LineItemID（AutoNumber）链接到两个表1）LineItemsExpenseDetails（一对多关系）和2）LineItemsPaymentDetails（一对多关系）。逻辑是一个合约可以有多个订单项，每个订单项可以有多个费用和多个付款。不确定关系是否以最佳方式设置。
创建三个数据表子表单：1）绑定到表LineItems的sfrmLineItems 2）绑定到表LineItemsExpenseDetails的sfrmLineItems和3）绑定到表LineItemsPaymentDetails的sfrmPayments
创建一个表单以将其全部拉到一起，如下所示：未绑定的文本框，用于选择要查看的合同。插入sfrmLineItems以输入与所选合同相关的多个行项目。接下来，我插入了一个Tab Control并将第一页命名为Expenses。并插入子表单LineItemsExpenseDetails。第二页我将其命名为付款。并插入子表单LineItemsPaymentDetails。
有一段时间无法获得费用和付款子表单链接到第一个LineItem子表单的行项目编号。我读到了一个解决方案，您可以在Master子窗体中插入未绑定的文本框，并引用要用作链接的字段。在需要更新的子窗体中，引用分配给此未绑定文本框的名称。这似乎适用于Expense子表单但是当应用于Payment子表单并且我预览了表单时，它无法控制地闪烁。似乎无法找到这种闪烁的解决方案或备用数据库设置解决方案。非常感谢您的帮助。
在此先感谢，
CJ
Hello,
I have been trying to resolve this problem for a while and can''t seem to find a solution anywhere.
I have a database with the following relationship setup: A) Contract table with field AssetID (AutoNumber) linked to table LineItems (One to many relationship). B) LineItems table with field LineItemID (AutoNumber) linked to two tables 1) LineItemsExpenseDetails (One to many relationship) and 2) LineItemsPaymentDetails (One to many relationship). The logic is that one contract can have multiple line items and each line item can have multiple expense and multiple payments. Not sure if the relationship optimally setup.
Created three datasheet subforms: 1) sfrmLineItems bound to table LineItems 2) sfrmLineItems bound to table LineItemsExpenseDetails and 3) sfrmPayments bound to table LineItemsPaymentDetails
Created a form to pull it all together as follows: An unbound text box to select the contract to view. Inserted sfrmLineItems to enter the multiple line items related to the selected contract. Next I inserted a Tab Control and named the first page "Expenses" and inserted the subform "LineItemsExpenseDetails". The second page I named "Payments" and inserted the subform "LineItemsPaymentDetails".
For a while could not get the expense and payment subform to link to the first LineItem subform''s line item number. I read about a solution where you would insert an unbound text box in the Master subform and reference the field that is to be used as the link. In the subform that needs to be updated, reference the Name assigned to this unbound text box. This seemed to work ok for the Expense subform but when applied to the Payment subform and I previewed the form, it flickered uncontrollably. Can''t seem to find a solution to this flickering or an alternate database setup solution. Your help is deeply appreciated.
Thanks in advance,
CJ
推荐答案
这是其中一个问题，至少对我来说，如果没有物理数据库就不可能回答。
This is one of those questions, at least for me, that is impossible to answer without having the physical Database in front of me.
ADezii -
感谢您的快速回复。我已附上数据库供您审核。
CJ
ADezii -
Thanks for your quick response. I have attached the database for your review.
CJ
给我一点时间，当我有机会的时候，我会好好看看它。
Give me a little time, and when I get a chance, I''ll have a good look at it.
这篇关于如何链接两个子表单导致表单不停闪烁？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
