Adjustment types

[Tom Zaccaria]

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

[cmcgehee]

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

[Tom Zaccaria]

Thank you

drtmz

[Tom Zaccaria]

Actually the following query works better.

SELECT * FROM definition

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

drtmz