Hello,
I have two tables in a one to many relationship.
tbl_Test & tbl_tech
I may have several Tech's working on one test.
I was trying to get a query where I have one record from tbl_Test
with the tech ID's show in a single text field.
For instance:
tbl_test ID tbl_tech
100 W1
100 W2
101 W5
101 W6
102 W7
Results:
100 W1,W2
101 W5,W6
102 W7,
I found some code but it involves creating temp tables. I did not want to bloat my database. Suggestions?
Thanks again
I have two tables in a one to many relationship.
tbl_Test & tbl_tech
I may have several Tech's working on one test.
I was trying to get a query where I have one record from tbl_Test
with the tech ID's show in a single text field.
For instance:
tbl_test ID tbl_tech
100 W1
100 W2
101 W5
101 W6
102 W7
Results:
100 W1,W2
101 W5,W6
102 W7,
I found some code but it involves creating temp tables. I did not want to bloat my database. Suggestions?
Thanks again