将重复记录放在第二个表中 [英] place duplicate record in 2nd table

问题描述

我正在使用命令按钮来复制记录，我想将复制的记录放在不同的表中，如果是这样，我怎么能实现这一点？


感谢您的帮助！

I''m using a command button to duplicate a record and I would like to place the duplicated record in a different table, is it possible if so, how i can achive that?

Thanks for your help!

推荐答案

您可以使用附加查询执行此操作，但除非您打算在将原始表格复制到原始表格后将其删除新表，你将严重违反正常化！


欢迎来到TheScripts！


Linq ; 0） >

You could do this with an Append Query, but unless you intend to delete the record from the original table after copying it to the new table, you''d be in gross violation of normalization!

Welcome to TheScripts!

Linq ;0)>

考虑你需要什么。

有些情况（备份等），规范化问题不算数。

您的情况是其中之一吗？只有你知道这一点，但这是一个值得考虑的重要问题。

Consider what you need.
There are situations (backup etc) where normalisation issues don''t count.
Is your situation one of them? Only you know at this point, but it''s an important issue to consider nevertheless.

感谢您的回复...

好​​的，我改变了命令按钮到复选框（因为我只能弄清楚如何使用复选框执行追加查询）。复制后如何从第一个表中删除记录？没有运行另一个追加查询...是否可能？

thanks for your reply...
Ok, i changed the command button to a check box (because i could only figure out how to do an append query with a check box). How do i delete the record from the first table after duplicating it? that is without running another append query...is it possible?

这篇关于将重复记录放在第二个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！