When booking in a Patient I need to know if I have two or more of the same or similar surname.
on booking in I press a button which is called "Name Check" and this finds these.
The script is:
Go to Layout ("Name Check")
Enter Find Mode (Restore) (Table:: Patient Released: ("No")
Go to Field (Table::Surname)
Insert from Last Visited (Select)
Go to Field (Table::Patient Released)
Insert Text ("No")
At present this will show Patients I have in of the same name like "Richards" but then also brings up Patients like "Richardson".
I don't want this I just want specific same names.