Open Dental Forum

Posted: **Thu Feb 06, 2020 7:59 am**

Is there a way to see the AdjTypes in the Adjustment table without having to switch between raw and human readable windows?
Basically, I want to know what each generated AdjNum refers to in plain English as in #10 = 10% cash discount when I query this table.

Thanks,
drtmz

Posted: **Thu Feb 06, 2020 8:06 am**

Yes, you can join on the definition table. Here's a little example:

Code: Select all

SELECT d.ItemName AS AdjTypeName,a.*
FROM adjustment a
LEFT JOIN definition d ON d.DefNum=a.AdjNum

Posted: **Thu Feb 06, 2020 11:49 am**

Thank you

drtmz

Posted: **Mon Feb 10, 2020 7:00 am**

Actually the following query works better.

SELECT * FROM definition

Switch to Raw View and look at DefNum and ItemName columns.

drtmz

Open Dental Forum

Adjustment types

Adjustment types

Re: Adjustment types

Re: Adjustment types

Re: Adjustment types