Hi
I have client with 250,000 customers (mintime).
I have vfp table for cusomers (Id column six digits - 100001,100002..).
Each customer has personal card paper wich filled (two sides of the card) with printed and customer handwriting.
Now
The client want to scan all the pictures and to be able to load picture by cusomer id.
Each card size is 5.6 inch * 4.3 inch.
So, we have 500,000 cards (250 card - two sides).
I will have to name the card by id+a and id+b (100001a, 100001b, 100002a...) for the both card sides.
I ask about the best way storing\scanning\zipping (I need the handwriting clear), in vfp table \ SQL \ windows path? (There is not SQL in my client network and I prifer to other way if its possible) or any other thing that can help.
Thank's
Thank you
Chaim