在表单中进行编辑更改所有..但不应该 [英] Making Edit in Form Changes All..But Shouldn't
问题描述
我输出特定公司在特定日期的特定业务线上工作的小时数，并将其发送到已提交的小时表格。 业务线框仅可由管理员编辑，但是，当更改时，它会更改所有记录，而不仅仅是单个实例。
我已附加2图片，一个在变化之前，一个在之后。
请记住，我只想要1个LOB来改变。
如果我可以提供其他任何事情，请告诉我。
我觉得它可能与配对键或查询有关，但除此之外，其他所有内容都在数据库中工作，所以我是犹豫要做出改变。
谢谢。
I am outputting Hours worked on a specific line of business of a specific company on a certain date, and sending them to a ''Submitted Hours'' form. The Line of Business box is editable only by an Admin, however, when it is changed, it changes all of the records, not just that single instance.
I''ve attached 2 images, one before the change and one after.
Keep in mind, I only want 1 LOB to change.
If I can provide anything else, let me know.
I feel as though it might be something with the pairing keys, or a query, however everything else works in the database aside from this, so I am hesitant to make changes.
Thanks.
推荐答案
看起来没有唯一的标识符继续表单Access不会将此选择限制为当前记录.....
作为解决方法，在更新时，您可以右键单击日期，然后公司应用过滤所以只显示一行。
然后更新字段。
或要求程序员纠正他的设计:-)
Nic; o）
Looks like there''s no unique identifier and in a continues form Access doesn''t limit such a selection to the current record.....
As a workaround, when updating, you can right-click the date and then the company to apply a filter so only one row is displayed.
Then update the field.
Or ask the programmer to correct his design :-)
Nic;o)
我是''程序员''..我接管了一个部分完成的数据库，甚至不知道这个表格是可编辑的。我认为有一个不匹配的连接，但是，除了编辑 - 所有的输出都很好。有一个附加查询转到表单，所以我质疑这是否可能是问题的来源。
I am the ''programmer'' .. I took over a partially completed database and didn''t even know this form was editable. I am thinking that there is a mismatched connection, however, other than the editing - all of the output is fine. There is an append query that goes to the form, so I am questioning if that could be a source of issue.
追加查询不能去一个表格。附加查询将记录添加到表中。
表单可以显示表或SELECT查询。该表可以由追加查询创建，或者通过追加查询添加到其中的记录，但是表单无法显示追加查询。
我猜你有2或者更多表连接在一起而不是编辑主表，您不小心编辑了查找表。
尝试谷歌寻求一些关于如何使用查找表创建组合框的帮助，看看是否为你澄清它。
A append query cannot "go" to a form. An append query adds records to a table.
A form can show a table or a SELECT query. The table could have been created by an append query, or had records added to it by an append query, but a form cannot show an append query.
I am guessing that you have 2 or more tables joined together and instead of editing the master table, you are accidentally editing the lookup table.
Try to google for some help on how to create a combobox using a lookup table, and see if that doesn''t clarify it for you.
这篇关于在表单中进行编辑更改所有..但不应该的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
