表格或表格问题 [英] Table or Form problem
问题描述
我有两张桌子：
CustInfo（包含所有客户信息的主表）
CustPay（收到付款的历史表）
它们通过字段TblCustPay Lookup从Custinfo链接到TblCustPay字段ID（自动编号）
我使用CustInfo中的字段进行查询：
ID
名称
地址
Lst_Pay
Bal_Amt
和来自CustPay的字段：
ChkNum（需要附加到custpay tbl）
ChkAmt（需要附加到custpay tbl）
RecDate（需要附加到custpay tbl并在custinfo tbl更新到Lst_Pay）
然后我需要从输入值更新Bal_Amt（custinfo tbl）减去ChkAmt
然后我做了一个来自查询的所有这些字段的表单
可以浏览来自Custinfo的记录，但CustPay中的字段没有任何变化。
另外，我输入数据并将其放入冷杉的第一份CustPay记录仅限时间。
我尝试了各种代码编辑和编辑示例。
我现在有偏头痛试图解决这个问题。
非常感谢任何指导。
I have two tables:
CustInfo (main table with all customer info)
CustPay (History table for payments received)
They are linked as from Custinfo by field TblCustPay Lookup to TblCustPay field ID (autonumber)
I made a query with the fields from CustInfo :
ID
Name
Addr
Lst_Pay
Bal_Amt
and with fields from CustPay:
ChkNum (need appended to custpay tbl)
ChkAmt (need appended to custpay tbl)
RecDate (need appended to custpay tbl AND updated to Lst_Pay in custinfo tbl)
Then I need to update Bal_Amt (custinfo tbl) minus ChkAmt from the input value
Then I made a form with all these fields from the query
Can navigate through the records from Custinfo but nothing changes in the fields from CustPay.
Also, I entered data and it placed it in the first record of CustPay tbl the first time only.
I have tried various samples of code editing and editing.
I now have a migraine trying to figure this out.
Any guidance is greatly appreciated.
推荐答案
我的第一个想法是检查它是否是可更新的查询。如果不是 - 这可能会导致各种问题。
如果你发现它是，那么如果我们让你的SQL查看查询，它可能会有所帮助。
My first thought would be to check if it''s an updatable query. If not - that could cause you various problems.
If you find it is, it might then help if we had your SQL to look at for the query.
表单的查询是从哪个构建的？它被设置为更新类型。
我相信我需要一个查询或过程来获取表单数据并将其放入表中。正确吗？
如果是这样的话，那就是我没有的东西，需要一些关于它所涉及内容的指导。我认为。但是可以查询/做我需要做的所有事情，我想作为after_event？代码
The query the form is built from ? It is set as update type.
I believe I need a query or procedure that takes the form data and puts it in the tables. Correct ?
If so, that is what I don''t have and need some guidance on what is involved in it. I think. But can one query / do all I need done, I suppose as an after_event ?code
...
然后我用查询中的所有这些字段制作了一个表格
...
...
Then I made a form with all these fields from the query
...
你说的话对我来说没什么意义。
你似乎没有对我的帖子做出任何可理解的回复，所以我无法继续这样做。
What you say makes little sense to me.
You don''t seem to have made any intelligible response to my post so I have no way to proceed with this.
这篇关于表格或表格问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
