Carl writes "If you want to create a web report, based on a table that has a one-to-many relationship with another, how can you condense all the many values in the many table into one field on the one table (for display only)For example, you have a table of Rep names, and they have responsibilities for many Countries. This could be stored in the database as a Rep table and a RepCountry table, with a one-to-many relationship between them.I want to efficiently list them all like this :Rep Name Countries---------- -------------------------Joe Bloggs France, Belgium, HollandFred Smith UK, IrelandJack Jones Germany, Denmark
"
Concatenate row values into one field 
Posted - 2002-03-14 : 09:22:00
