I have a split form with 10-15 fields. Each of these fields is a combo box. The trouble I am having is sorting the data in the datasheet of the split for. I want to sort ascending by "ProductTypeName", then ascending by "Parent SKU" and then ascending by "ProductSizeID".
How can I do this when each of my combo boxes have an ID and then a name? Example below:
ProductTypeID ProductTypeName 1 Apron - Bib 2 Apron - Waist 3 Bag - Backpack 4 Chef Coat 5 Crewneck 6 Fleece - Glove 7 Fleece - Jacket 8 Fleece - Vest 9 Oxford 10 Pharmacy Coat 11 Polo 12 Poplin 13 Twill 14 Vest - Ladies' 15 Vest - Men's 16 Yoga Mat 17 Apron - V-Neck
ID Parent SKU 3 BIG900 4 BIG927 5 BIG932 6 DAQ108 7 DAQ112 8 SAL105 9 SIZ105 10 SNS106 11 BFT1157 12 BIG982 13 FDS531 14 ALS122 15 DAQ110 16 JWL159 17 AMT196 18 AMT197 19 AMT198 20 AMT199 21 AMT200 22 AMT201 23 AMT202 24 AMT203 26 PKB119 28 EBC122 29 EBC123 30 EBC124 31 EBC125 32 EBC126 34 JWL160
ProductSizeID Size 1 XXS 2 XS 3 SM 4 MD 5 LG 6 XL 7 2XL 8 3XL 9 4XL 10 5XL 11 6XL 12 7XL 13 8XL 14 9XL 15 LGT 16 XLT 17 XXLT 18 3XLT 19 4XLT 20 5XLT 21 6XLT