I am just learning to program with FoxPro 2.0 (never done anything with
databases before) and I had a couple of questions:
1) Is there anyway to check for duplicate records using asingle field as the
key that is as easy as marking the field a key when you create it (I am told
you can do this in paradox)? I am trying to avoid having to scan the whole
database as I enter each record...
2) Is there any way to avoid blank lines when doing mailing labels and having
an empty field sometimes?
3) Is there a way to transfer a data set from Quattro (as SDF is fine) into
FoxPro, and then have go through the database and add up the occurrences of
the same name? I have a large database of orders with the structure:
Order Number Name etc..
124234234 Doe, John
1334534 Doe, Jane
12354345 Doe, John
and I want to count up how many orders each person has... I figured some way
of sorting the database, finding the first occurrence, counting, finding next,
etc. I want to be able to do this without having to manually key in each name,
so when new customers come in they automatically get added...
(this one may not be so easy, but any and all help is appreciated)