asked on Implementing double entry system in access
I need to develop a database system with sql server 2000 on the back end and access 2003 on the front end.The nature of the system is such that you should capture a form twice (double entry) .One person should enter the form into the table and a different person should enter the same form into the same table and some checks are to be done to make sure all the entries by the 2 people do agree and if they are the same one is deleted so that one entry remains in the table.If there any different values in the fields the two forms are saved in the same table and later the forms can be opened to modify until all fields do agree for the 2 entries and one is deleted .Any help how i can implement this
DatabasesMicrosoft Access
Last Comment
Scott McDaniel (EE MVE )
That's quite a broad question (especially for 50 points!) but the one thing I would suggest is that you DON'T go deleting records in your 'data entry' table; instead, I'd suggest copying 'validated' records across into a 'final data' table (and flagging them in the first table so you know they've been dealt with).
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.