In Foxpro, a common technique when adding data to files on a multi-user system was to copy the structure of the master file from a network drive to the local hard drive with 0 records, add new records to the temporary file and do the necessary validation, and then append back the entire temporary file onto the master file on the network.
This could be used for example when adding time recording sheets from employees to a timsheet database. Each timesheet would have multiple records, and none of these records can be committed to the main table until the internal integrity of all records on the timesheet are validated. A simple requirement might be that the sum of the hours entered would add up to 8.
How would this be done elegantly in Access, where multiple users could add records simultaneously?
This could be used for example when adding time recording sheets from employees to a timsheet database. Each timesheet would have multiple records, and none of these records can be committed to the main table until the internal integrity of all records on the timesheet are validated. A simple requirement might be that the sum of the hours entered would add up to 8.
How would this be done elegantly in Access, where multiple users could add records simultaneously?
