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#?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mark records already read so duplicates are not created
- Thread starter rollypac
- Start date
craigsboyd
IS-IT--Management
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
SweetPotato Software Website
My Blog
- Status
Similar threads
