troubleshooting Question

Implementing double entry system in access

Avatar of Cleohwinya
CleohwinyaFlag for South Africa asked on
DatabasesMicrosoft Access
2 Comments1 Solution619 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros