> >
> That is very almost what I want I will try to explain it again.
>
> Scenario:
> Replication Log
> ~~~~~~~~~~~~~~~
> POS_BILLOFMATERIAL
> POS_BILLOFMATERIAL
> POS_BILLOFMATERIAL
> MSFRAMES
> MSMOUNTS
> POS_MISC_STOCK
> MTRL_GLASSPRODUCTS
> MTRL_GLASSPRODUCTS
> MTRL_GLASSPRODUCTS
>
> I would want to do a distinct selection so I get the following result
> MTRL_GLASSPRODUCTS
> MSMOUNTS
> POS_BILLOFMATERIAL
> MSFRAMES
> POS_MISC_STOCK
>
> Then I would want to itterate through this list and do the
> replication table
> by table.
> First problem some tables need to be replicated before others so the list
> needs to be
> sorted in a specific way. I cant sort it alphabetically so I need
> to lookup
> a
> weight for the table to know how to sort it. Here is typically
> what I would
> like to end up with after I have sorted it to weigth.
>
> TableName Weight
> MTRL_GLASSPRODUCTS 4
> MSFRAMES 8
> MSMOUNTS 9
> POS_MISC_STOCK 15
> POS_BILLOFMATERIAL 18
>
> I hope this helps to explain better.
>

I used Helen's previous suggestion created a view and then did a join
on the view and the lookup table. It solves my problem.

Thanks
Groete
Gerhardus