AnsweredAssumed Answered

Allow Duplicate but set up a dialog to alert the duplicate

Question asked by KatG on Dec 12, 2012
Latest reply on Dec 22, 2012 by philmodjunk

Title

Allow Duplicate but set up a dialog to alert the duplicate

Post

     OK one more question and I promise (I'll try really hard :) not to bug you anymore today.

     I currently have several patients with the same last name, scheduled for the same day. How do I format to cue me with a ""Name Alert"  show dialog or something else?

     I did a forum search and the posts seem to be related to different fields or dates I didn't come across one that seemed to address this.

     I created an a name alert field but I am in the dark as to how to write the formula condition for the format     

     The Table     PATIENT::ID_Pt             primary key

                          PATIENT::LastName     Text Field

                          PATIENT::NameAlert    Text Field

     I need something like "when the ID_Pt doesn't equal the ID_Pt in another record but the Last Name fields are equal... launch a dialog box.... "Name alert"

     Is my reasoning on the right track?

Outcomes