Items table Revisited
After 15 posts this might still be a bit confused, not sure if you still
have an open question. But here's a thought on the sorting.
If all of your descriptions are as precisely formatted and entered as your
example, you could just use 4 fields, and derive your description from them
Field: Item (text)
Field: Dimension1 (numeric)
Field: Dimension2 (numeric)
Field: Type (text)
And sort by those.
And then derive your description from those whenever you need it:
=[Item] & " "& [Dimension1]&" x "& [Dimension2]&" "&[Type]
|