searching for patient by thier wireless Number/Mobile

[alhalwachi]

Hi everyone

In the "Select Patient" form, how can i search for patients with thier wirelss numbers/Mobile numbers? In other words, how can i add an extra seach filtering field such as the patient WirelessPh PatDetails into the form?

Thanks

[drtmz]

How about this little down and dirty query?

SELECT PatNum, WirelessPhone from Patient
WHERE WirelessPhone = '(###)-### ####'
# add phone number above


drtmz

[Hersheydmd]

Hi everyone

In the "Select Patient" form, how can i search for patients with thier wirelss numbers/Mobile numbers? In other words, how can i add an extra seach filtering field such as the patient WirelessPh PatDetails into the form?

Thanks

You don't need to. The phone field in the Search for Patients window will search all phone numbers, home, work & wireless.

[alhalwachi]

Thankssssssss really

[irfan]

yep.. its nice when the phone rings and i wanna know who the front desk is talking to.. just look at the caller id, punch in #, voila.