How do I copy data from one record into many

  • Thread starter Thread starter LarryH
  • Start date Start date
L

LarryH

I am new to Access and have one small problem I can't seem to solve. I have
a database with multiple order records for people. Each person has a unique
ID, and is on the datbase multiple times, but only one of each record has
the address, and phone, etc. I need to copy the data from that record into
all records with the same IDs.

I know I can creat multiple tables, but I need it in a single table so it
can be exported to a mailing/accounting program.

Any ideas would be appreciated.
 
Copying the data from that record into all records with the same IDs is the
wrong thing to do! Create a query that includes the table with the address,
phone, etc and the table with the data you want to export. You should already
have a relationship between these tables so you should see a line joining the
tables on the ID field. Export the query to your mailing/accounting program.
 
Back
Top