Allow Duplicate but set up a dialog to alert the duplicate
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?