I have been reading the FAQ's and don't know the best and easiest way to approach this. Plus, I don't have a lot of experience writing SQL statements, so would appreciate some help.
I have a table "Main" that has a one-to-many relationship with table "tbl_names". They are linked on field "ID". I want to combine all of the corresponding records in tbl_names.name into Main.combined_names where ID is the same. I would like each name to be delimited with a line break. Could someone help me with the SQL, etc.? Thanks a whole bunch.
Example:
table "Main":
ID Description
1 This is the description
2 This is another description
table "tbl_names"
ID Name
1 Smith, John
1 Rocket, Johnny
1 Violet, African
2 Doe, Jane
2 Doe, John
I have a table "Main" that has a one-to-many relationship with table "tbl_names". They are linked on field "ID". I want to combine all of the corresponding records in tbl_names.name into Main.combined_names where ID is the same. I would like each name to be delimited with a line break. Could someone help me with the SQL, etc.? Thanks a whole bunch.
Example:
table "Main":
ID Description
1 This is the description
2 This is another description
table "tbl_names"
ID Name
1 Smith, John
1 Rocket, Johnny
1 Violet, African
2 Doe, Jane
2 Doe, John