Help for Automating a process

[koilena]

Hello,

I am looking for a way to automate a process that I have to take care of but i do not know nothing about macros.
I hope some of you will be able to help on this.

Basically, I have a list of product (quite long actually)
ex :
<table style="border-collapse: collapse; width: 101pt;" border="0" cellpadding="0" cellspacing="0" width="135"><col style="width: 101pt;" width="135"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 101pt;" height="20" width="135">Collier_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Pendentif_d</td> </tr> </tbody></table>
And I need to associate each item that carry the same letter with all the other that have this letter like this :

As you can see I do not always have the same number of items within the groups (a,b,c,d,...)

<table style="border-collapse: collapse; width: 202pt;" border="0" cellpadding="0" cellspacing="0" width="268"><col style="width: 101pt;" span="2" width="134"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 101pt;" height="20" width="134">Parent </td> <td style="width: 101pt;" width="134">Child</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_a</td> <td>Bracelet_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_a</td> <td>Boucles d'Oreilles_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_a</td> <td>Bague_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_a</td> <td>Collier_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_a</td> <td>Boucles d'Oreilles_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_a</td> <td>Bague_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_a</td> <td>Collier_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_a</td> <td>Bracelet_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_a</td> <td>Bague_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_a</td> <td>Collier_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_a</td> <td>Bracelet_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_a</td> <td>Boucles d'Oreilles_a</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_b</td> <td>Bracelet_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_b</td> <td>Boucles d'Oreilles_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_b</td> <td>Bague_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_b</td> <td>Collier_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_b</td> <td>Boucles d'Oreilles_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_b</td> <td>Bague_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_b</td> <td>Collier_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_b</td> <td>Bracelet_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_b</td> <td>Bague_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_b</td> <td>Collier_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_b</td> <td>Bracelet_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_b</td> <td>Boucles d'Oreilles_b</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_c</td> <td>Bracelet_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_c</td> <td>Bague_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_c</td> <td>Collier_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_c</td> <td>Bague_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_c</td> <td>Collier_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_c</td> <td>Bracelet_c</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_d</td> <td>Bracelet_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_d</td> <td>Boucles d'Oreilles_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_d</td> <td>Bague_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Collier_d</td> <td>Pendentif_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_d</td> <td>Collier_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_d</td> <td>Bracelet_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_d</td> <td>Bague_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Boucles d'Oreilles_d</td> <td>Pendentif_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_d</td> <td>Collier_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_d</td> <td>Boucles d'Oreilles_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_d</td> <td>Bague_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bracelet_d</td> <td>Pendentif_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_d</td> <td>Collier_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_d</td> <td>Bracelet_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_d</td> <td>Boucles d'Oreilles_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bague_d</td> <td>Pendentif_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Pendentif_d</td> <td>Collier_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Pendentif_d</td> <td>Bracelet_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Pendentif_d</td> <td>Boucles d'Oreilles_d</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Pendentif_d</td> <td>Bague_d</td> </tr> </tbody></table>
Do you have an idee on how I could automate that, because it is taking me crazy time to do it manually?

Thanks a lot!!
Koilena

 

[Gerald Higgins]

Hi, welcome to the board.

I don't understand the relationships.

For example on line 1, Collier_a is the parent of Bracelet_a.
But on line 4, Bracelet_a is the parent of Collier_a.

How does that work exactly ?

And both Collier_a and Bracelet_a are parents of Bague_a.

How does that work exactly ?

 

[koilena]

Hello,

Thank you for trying to help me with my weird problem.

Actually within a family (a. for exemple), each product should be linked to one another and be at the same time the parent for all and the child for all the other items (it is a suggested relationship).

We want to say collier a goes with bracelet a and bague a but we also want to say that bracelet a goes with collier a and bague a

Hope it is more clear this time.

Thanks anyway for your time.
Koilena