I am a bit of a novice when it comes to Access. I have recently developed a simple database for doing conflict checks for a local law firm.
What I want to be able to do is simple. When my staff enter a new client record, and click my save command button. I want Access to automatically run a conflict check against the new client's last name and opposing party, with records already stored in my database.
For example, I am entering John Smith's as a new client. Example fields: First name: John , Last name: Smith
When I click save, I want a window warning to pop up and say, "Potential Conflict" and bring up the records of conflict - any records that contain "Smith" in the fields of: Last name , or Opposing party.
Any ideas?