Hello. You question seems simple enough but presents many challenges. The volume of items within the categories seems to make even "filtering’ the items a difficulty.
The only solution I can present is using a macro to locate each item in a category based upon the WGTV code. To demonstrate, I have a sample.
In the sample there is one form for demonstration. Contents: Name, WGTV code, Ware, Group, Type and Variety. To use, enter a Name (any); enter the eight digit WGTV code; when you TAB (or ENTER)to “Ware” field, a macro executes and using the first two digits of the WGTV code it displays the result; you must do the same for the remaining fields.
You MUST use the
Enter key through the Ware, Group, Type and Variety fields. Using the mouse to select a field can create problems. The same is true if the WGTV field is changed - skipping the
Enter process for any of the four fields can leave erroreous results.
There are five tables. “ANCIENTITEM” is filled in by the form. “WARE” has a key of two digits (the first two in the WGTV code) and the description. “GROUP” has a key of four digits (the first four in the WGTV code) and a description. The first two digits represent the “WARE” and the last two digits represent the unique “GROUP” within the “WARE”. “TYPE” is similar with six digit key - 2 for WARE, 2 for GROUP and 2 for unique TYPE. “VARIETY” uses the full eight digits.
Even if you don’t want to use macros, maybe this will benefit someone else or even trigger a different thought by someone else.
As you may understand, there is limited data in the tables provided. Simple codes such as 01010101 and 02020101 and others will work. The code does provide default error text for information not fould in a table so any eight digit code will be accepted.