I have a project to covert a a VFP program to VB. The project involves taking a small list of distributors about 30,000 many of whom are inactive and merging it with sales for the month.
Basically, I have to take one pass and get their personal sales. Then I have to take 5 or more passes and get the sales of their downlines. The downlines are not directly connected to the top of the tree only to their immediate upline.
I've tried using DataTables but that seems to be difficult as the search routines don't seem to work well.
I'm thinking of just keeping it in VFP or trying Access. The only reason to move to VB is Microsofts plans.
Basically, I have to take one pass and get their personal sales. Then I have to take 5 or more passes and get the sales of their downlines. The downlines are not directly connected to the top of the tree only to their immediate upline.
I've tried using DataTables but that seems to be difficult as the search routines don't seem to work well.
I'm thinking of just keeping it in VFP or trying Access. The only reason to move to VB is Microsofts plans.