How do I set up a 1 to many query

[cowboy]

I have a name field and each name field has x number of associated field b.



My ideas so far are to take the string b and add it to a variable for each b in x and then it would display a string of all the b's and its assocaited name. I am not sure the syntax to do this.

So if I could get help on the syntax or if I should be headed in another direction, thank you.

[pbaldy]

This type of thing?

Return a concatenated list of sub-record values

[jgelpi16]

Let me see if I understand. In two Tables and you have two fields: Table1.Name and Table2.B. Table1.Name is unique and Table2.B has many. Table1.Name could be associated with several in Table2.B. You want a query to take every instance where Table1.Name is associated with Table2.B and Append it to Table3.Combined.

[cowboy]

Let me see if I understand. In two Tables and you have two fields: Table1.Name and Table2.B. Table1.Name is unique and Table2.B has many. Table1.Name could be associated with several in Table2.B. You want a query to take every instance where Table1.Name is associated with Table2.B and Append it to Table3.Combined.

Everything correct except the last sentence. What I want is to have a query that pulls certain information for each table1.Name and one of the things I want is a list of all the table2.B associated.

I think pbaldy's link is what I am looking for but I just got in today I need an hour to implement it and try it out.