I have a contact table and a category table. One contact can be assigned several categories.
I want to be able to have a datasheet in a form show me all vital contact info (name, address, etc) across one row as well as
show in one cell of the row a string of however many of the categories this contact has been assigned, separated by commas.
For instance, I'd like the columns to look like this:
Joe Smith---(555) 555-5555---123 North Street---Volunteer, Civic Leader, Government
Is there a way to write into a query to take the contact ID and for every category assigned to it, string them together
(like, above, *Volunteer, Civic Leader, and Government* are 3 categories) into one 'sentence'? Then, I could set the record
source for Category in my datasheet to this column in the query.