apraily
12-17-2015, 10:58 AM
Hi, i have to merge this two stylesheet
The first one "DB" is a database of products, is a music shop.
As you can see i have 3 columns: the id of the product, the title, the price, and the tracklist.
Title and price are ok, but the column of the tracklist for now is empty.
The second one "TRACKS" is where my tracks are. Thre columns, the first one is the id of the product who refer, the second column is the number of the track, and the third column is the title.
I need to merge all the tracks on different lines for each product from "TRACKS" in a single cell of the tracklist in "DB"
The real BESTBESTBEST is to have a structure like this in the cell tracklist of "DB" :
<table>
<tbody>
<tr>
<td>1.</td>
<td>TITLE_1</td>
</tr>
<tr>
<td>2.</td>
<td>TITLE_2</td>
</tr>
<tr>
<td>3.</td>
<td>TITLE_3</td>
</tr>
</tbody>
</table>
It's really Tricky and i'm struggling for days to find a solutions, fact is that i don't know VB to make a script that can help me to do it...
Kind Regards,
Michele
The first one "DB" is a database of products, is a music shop.
As you can see i have 3 columns: the id of the product, the title, the price, and the tracklist.
Title and price are ok, but the column of the tracklist for now is empty.
The second one "TRACKS" is where my tracks are. Thre columns, the first one is the id of the product who refer, the second column is the number of the track, and the third column is the title.
I need to merge all the tracks on different lines for each product from "TRACKS" in a single cell of the tracklist in "DB"
The real BESTBESTBEST is to have a structure like this in the cell tracklist of "DB" :
<table>
<tbody>
<tr>
<td>1.</td>
<td>TITLE_1</td>
</tr>
<tr>
<td>2.</td>
<td>TITLE_2</td>
</tr>
<tr>
<td>3.</td>
<td>TITLE_3</td>
</tr>
</tbody>
</table>
It's really Tricky and i'm struggling for days to find a solutions, fact is that i don't know VB to make a script that can help me to do it...
Kind Regards,
Michele