>>Hi,
>>
>>I'm using a basic loop to wait for new records to show up in a table. When a new record shows up, I process it and then wait for the next record to show up... sounds simple...
>>
>>But some records are slipping through un-detected. So of course, my totals are off. Interestingly, most (but not all) of the un-detected records are added by the same workstation.
>>
>>Any ideas why this might be happening? Any suggestions to improve this logic?
>>
>
>Why not add this table to a database and add an Insert trigger to the table?
>Then when a new record is added, the insert trigger automatically fires.

I just thought of another point... the processing can take some time to complete (up to a full second). So what would happen if another record was added during that second?

TIA