How do I copy data from one record into many

[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.

[PC Datasheet]

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.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"LarryH" <lh*******@cox.net> wrote in message
news:1Q0Jb.36558$gN.18048@fed1read05...

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.