表更新为另一个表的表单输入。 [英] Table updates as form inputs into another table.

问题描述

我有2个表，一个表用于表单输入记录;另一张表是为了保持平衡。如何在输入表中输入新条目（+或 - ）时，我的余额表是否可以更新？非常感谢任何帮助!!!! = D

I have 2 tables, one table is for the form to input records; and the other table is for keeping balances. How can I get my Balances table to update as new entries (+ or -) is entered in the input table? Any assistance is greatly appreciated!!!! =D

推荐答案

猜猜你需要先阅读你可以找到的规范化文章：
http://bytes.com/topic/access/insights/

因为没有必要更新你的平衡表。

在需要时可以扣除适当的余额。


Nic; o）

Guess you need to start with reading the normalization article you can find at:
http://bytes.com/topic/access/insights/
as it''s not necessary to update your balance table.
The proper balance can be deducted when needed.

Nic;o)

Hi Nic; o），


我不确定你的意思是在需要时可以扣除适当的余额。你能解释一下吗？


谢谢！

Hi Nic;o),

I am not sure what you mean by "The proper balance can be deducted when needed." Can you explain a little.

Thanks!

Nico，


我能找到规范化文章。实践理论是有道理的。我不确定这将如何解决我的问题。


我创建了输入表，其中包含了所有记录以供我用于报告。我之所以想知道是否可以更新Balance表，是因为我有多种类型的Item。即椅子有100个，窗户有100个等等，共有10个项目。如何根据库存和删除的添加内容更新此数量？输入记录没有特定顺序。让我说我做了2把椅子。由于我正在添加2把椅子，那么我将如何创建更新余额的东西？

Nico,

I was able to find the Normalization article. The theories of practice makes sense. I am not sure how this will solve my question.

I have created the input table, in which it has all the records for me to pull into a report. The reason I was wonder if the Balance table can be updated, is because I have more then one type of Item. i.e. Chairs has 100, windows has 100, etc. a total of 10 items. How would I update this quantity based on add ins to the stock and removal? There is no specific sequence a record is entered. Lets say I make an entry of 2 Chairs. Since I am adding 2 chairs then how would I create something to update my balance?

这篇关于表更新为另一个表的表单输入。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！