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