concetenate with multiple identities

[tl mike]

I am trying to create a concetenate query to run another query.

My issue is I need the conc to run off of 2 identities to get all the conc fields with the correct type for a CSV export as we have a large number of identities.

Like you would see with a car there would be a car model I.E. a Mustang, then there would be color choices and other choices like upgraded race wheels.

So we would like to create a conc that shows the Car Model and the color choices, and then another conc to show the car model and the wheel choices.

Mustang: Color: Red $100, Blue $100, Green $0
Mustang: Wheels: Mag Race Wheels $1000, OE wheels $0, Red Race Wheels $500

So then later i can create another conc that shows:

Mustang: Color: Red $100, Blue $100, Green $0; Wheels: Mag Race Wheels $1000, OE wheels $0, Red Race Wheels $500

 

[jdraw]

That sort of output is sort of working against the principles of database.

see http://allenbrowne.com/func-concat.html

 

[tl mike]

I know that is why I am having troubles getting it to work.

Thanks for the link I will check it out and see if I can get it to work.