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".
the table name is "tblNewMI" and the primary key of the table (the first field) is "FPNumber".