#36205 - 03/21/1301:53 PMRe: Gridview Query Help Please
[Re: SusanTennier]
Softrak Support
Adagio Action Team
Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Well done!
FYI, you shouldn't need the RIGHT function on either side, as categories can only be 3 characters maximum.
Another way you could choose to tackle this is to create an additional view based on the Category code list (just the code and description), and link this to the view you are working on. You can put a filter on the Category list view to limit the list to just the 8 codes you indicated, and thus the user of the GV workspace can pick one (or more) categories to perform the link selection.
_________________________
Regards, Softrak Tech Support