Query help with OITM & OITG

[#1]

I am trying to make a query that will list items and the property names that have been checked from the properties tab, but can't seem to find a way to link them correctly. Anyone ever done it successfully? If so please help on how I can do it.

Thanks

[Former Member]

Hi,

There is no direct link between two tables. The fields are predefined in OITG. ItmsTypCod value holds 1 to 64 which equivalent to 64 fields namely QryGroupXX in OITM.

Thanks,

Gordon