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 |
#2
|
|||
|
|||
UPDATE records by copying from same table?
3 AAAAAA Ted Nugent Red Green Purple... etc
1236 ZZZZZZ Ted Nugent .......... The problem is that you shouldn't (1) be putting similar data in different columns like Red Green Purple and (1) if Ted is always Red Green Purple, then you shouldn't be putting this data in each record. Instead you should have another table about the individuals with this data. Besides Sammy Hagar is the Red Rocker - not Ted Nugent! -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Billp" wrote: 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 | |
|
|