Open Dental Forum

Thanks for the info, is there a direct link to feature requests rather than doing it inside the program?

When entering family members is there a way to make everyone have the same email but different numbers? -I know about the box in the "Email and Phone" section that says "Same for Entire Family" but when you click that it gives everyone the same wireless and work numbers as well. I'm kind of curious ...

Writing queries is complicated, but can be done with a bit of practice. I'm sure there's lots of tutorials out there on how to do things. That being said, for your particular case you'd want an INNER JOIN on the provider table using the patient's PriProv and the provider's ProvNum. Essentially, it ...

I mean it's basically this but I want it to select a specific provider? I keep getting all kinds of errors when trying to write the code: SELECT patient.LName,patient.FName,patient.MiddleI,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip,patient.PriProv FROM patient So instead...

I wish there was a like a key somewhere to see all the commands you could input for the queries. I'm looking for a query to show patients names and addresses for a specific doctor and I seem to having a hard time putting one together. The kicker is the doc has 2 profiles as Dr. T/Dr. T 2. I'd love t...

Can you remove a tooth surface button from the chart? I'd like to get rid of V

If you combine both queries you can get all the info: SELECT carrier.CarrierName, COUNT(DISTINCT p.PatNum) AS 'Patients',carrier.Address, carrier.Address2, carrier.City, carrier.State, carrier.Zip, carrier.Phone, carrier.ElectID FROM carrier INNER JOIN insplan ip ON carrier.CarrierNum=ip.CarrierNum...

I saw that one in the examples already, I appreciate all the help but If I could combine that query and one that adds the carrier info it'd be great but I'm having a hard time writing this sql. It's a bit of a learning curve if you havent done much with it. I thought I could just add carrier.address...

That list just lists out each patient. I just want the number in each like its listed in the lists/insurance carriers

Almost perfect but I also need the number of ppl on each carrier as well

Is there a way to get the Insurance carrier list printed? maybe by a query?
Basically if you select list at the top then insurance carriers I need that list printed out and can't find a query that lists this..