mark records already read so duplicates are not created

[rollypac]

My main table has multiple family members with the same envelope #.I have a 2nd table with envelope # as the key. Can I mark the records in the 2nd table after it reads them so it doesn't read them again when it gets to the next person with the same envelope#?

 

[craigsboyd]

Sure, create a flag field in the 2nd table call it "wasread" and make it a Logical datatype. Then before reading the records in your scan or whatever, replace all wasread with .F. Then as you read them check the value of wasread, if it is true then don't read the record, but if it is false read the record and replace wasread with .T.

SweetPotato Software Website
My Blog