How do I flatten data in a one to many relationship?

G

Guest

I have main table one record for each person (ID numbers, names, addresses,
etc.) in it and another table containing one record for each contact (id
number, date, type of contact, etc.) linked by a one to many relationship.
I am trying to flatten the contact table so I can make an export with one
record per person by concatonating the information together. Basically make
it one record per unique assention number and have another field containing
all the text that is associated with that assention number.

I'm sorry to ask a question that's probably allready been covered, but I
can't figure out the right words to search for. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flatten a one to many relationship result in a query 0
How to 'flatten' a self-referencing table? 1
multiple one to many 2
Query with one to many relationship 2
One-To-Many Relationship On One Row 4
Counting the sum of related records for a primary record 4
Entering data with many to many relationship 1
Can I "flatten" out a table 2

Top