> > I would do as you suggest - a relations table and then a join to
> give you a
> > resultset giving multiple people with each of their flags. I would,
> however,
> > use a treeview which handles the multiple people as groupings quite
> well.
>
> Thanks Alan
>
> I don't want to group the people at all, I need something like this
>
> Name Flags
> --------------------------------------------
> Fred Retired, Golfer, Subscribed
> Bob Retired, Fisherman
> Jack Employed, Family
>
> If I use the relations table, I don't know how I can retrieve a
> persons details + flags in a single select (even using a join, unless
> some names are duplicated)
>
> Maybe it's not possable to do what I want with the relation table,
> hence my thought of using an array within the PEOPLE table, although
> that's a bit of a ludge.
>
> Thanks for your help.
>
> David

The only way I know to get a string or comma separated values is to build it
in a selectable SP. You just need to be careful of the length of the return
string you declare and how to check it'slength as you build it before you
pass it back
Alan