2I have three combo boxes, EntityCombo, LOBCombo, and ProductCombo. Each combo box is populated by reference tables I made, Entities, Line of Business, and Products Working.
Each reference table has a column with the full names and a column with the abbreviations. Not all items have abbreviations. I am trying to filter the original table from Excel, Disclaimers. Disclaimers has three columns, Entities, Product/content, and Disclaimer.
Entities has entries like ABC in A16 or ABCD, ABC in A4. When selecting the first item of EntityCombo, which has EntityAbbreviation ABC, only items from Disclaimers with an exact match ABC in Entity appear. Disclaimers with Entity as ABC. ABCD or ABC, ABCDE do not appear.
