问题描述
我有两张桌子：
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.
推荐答案
你说的话对我来说没什么意义。
你似乎没有对我的帖子做出任何可理解的回复，所以我无法继续这样做。
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.
这篇关于表格或表格问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！