UPDATE records by copying from same table?

[Billp]

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

 

[Jerry Whittle]

3 AAAAAA Ted Nugent Red Green Purple... etc
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!