How to copy a record and save as a new record. (1 Viewer)

QMDirk

Member
Local time
Today, 02:27
Joined
Nov 16, 2019
Messages
52
Hello, can anyone tell me how to copy a record and save it with a different name? The primary index field in the table is Text-formatted but contains the sku numbers of a list of products. The table holding the records contains a lot of fields, 82 ti be exact, and one sku can vary from another sku by as little as one field. That's why I need to be able to copy one record, save it as a different [FPNumber], then alter the couple of fields that are different, rather than re-type all 82 fields.
the table name is "tblNewMI" and the primary key of the table (the first field) is "FPNumber".
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:27
Joined
Oct 29, 2018
Messages
21,358
Hi. You could try using an APPEND query.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:27
Joined
Feb 19, 2002
Messages
42,981
Your copy button, needs to prompt for the new name. pass that into the append query.
 

Users who are viewing this thread

Top Bottom