Hello everyone.
I'm not sure if my question has already been answered as I don't have a clue where to start.
The company I work at needs to produce box labels for a School Campaign for hundreds of children from one of it's partners and I'm having a problem with automating the layout of the labels.
To put it simple, let's say we have one box that will hold products that will be distributed to three children, so the logic database wise would be to group these three records into a single one, but the rows will not only have their names, as there will be other fields that need to be separate.
I'd need to translate something like this:
Into something like this:
I'd need this, so that then when I run our label printing software, it'll read the Child's Name field value as single record, containing those three separate values.
Is it possible to produce a query for this?