>>Saying OleDb Provider and I know you're doing Vb.Net this question is really meant how to do from VB.Net, right? Otherwise doing that with a single SQL (though might be possible with VFP's-I don't know) if ever could be done I think would be slow.
>
>Thanks for the sample, but you might have seen in the other message that I used the route of adding an additional field in Style.dbf for that which is maintained by the robot. This gives me maximum performance at run time.
I just visited that one. If that works for you then what can I say. Collecting synonyms for 76 parents should never be an issue performance wise (ie: if on the avg you had 1000 synonyms that still makes just 76000 which should take milliseconds).
Cetin