If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
UPDATE records by copying from same table?
Hi,
I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they all have unique auto numbered lines. Say for example ID Cust_ID FirstName LastName .............. 1234 ZZZZZZ Fred Jones ........ 1235 ZZZZZZ Bruce Watts ......... 1236 ZZZZZZ Ted Nugent .......... Now sitting at the start of the table is 1 AAAAAA Fred Jones Blue Green Orange.... etc 2 AAAAAA Bruce Watts RED Violet Green....etc 3 AAAAAA Ted Nugent Red Green Purple... etc How do I if it is possible Update the New Records with the added information, copy for each old record back into the new record. The Cust_ID's are different , the only two feilds that are common is the Firstname and The lastName. This table is a sub table of a sub table. The extra info cannot be directly inserted as the new records are created. Or if not easy would VBA be another option. Thankyou in advabce Regards Bill |
Thread Tools | |
Display Modes | |
|
|