Open Dental Forum

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

How about this little down and dirty query?

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


drtmz

alhalwachi wrote: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.

Thankssssssss really

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.