Blind double-entry

[LaRetta]

I have a data entry screen (form view) for entering large volumes of data. This data MUST be exact, as therapist paychecks are determined from it. In my old mainframe days, we had users perform a blind double-entry process to ensure accuracy. I want to implement the same thing on this process.

1) When entering an original batch, user may need to stop and come back to it and continue where they left off. Same with 'blind' second time through. These batch records would need to be isolated from 12,000 other existing records in the db. How would you isolate them (i.e., data field set to auto-enter, global, etc.)

2) Should I use an exact copy of the original data entry layout but have the fields be

[falkaholic]

How I'd do it (which isn't always the best way) is to have a 2 database. Both the same except for one database had the ID of the master database. The master will store all the double checked and correct records while the second is just for the entry. Have a button to flag the entry for comparison. Once there is 2 for the same master (use a count(relation::id) or something) do a field by field check with all the related fields. If they all match, copy them all in, and flag the master done.

[LaRetta]

I didn't want to respond until I had tried it. It works great! I really like the idea of a separate db, performing the double-check, then copying them to the Master. This keeps each 'batch' isolated and the Master receives only perfect records! Thanks for your help on this.