One-to-Many Relationship - Show into 1 field

[JF Bouthillier]

Hi all,

I have two tables with a one-to-many relatioship. Table1 has projects and
Table2 has resources. What is the best way to show (in a report) for a
specific project all the resources separated by commas.

Thanks a lot.

 

[kingston via AccessMonster.com]

Here's one way to do it:

http://www.accessmonster.com/Uwe/Fo...-values-into-a-single-record#68035f3852b6euwe