Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help..... I have rows of data that include part number as one field and shape as another field. The shape can be three options and is entered in the data sheet as either Square, rectangle, or "square and rectangle". How can I have the user click on square and have it pull up all parts with the discription of either square or "square and rectangle". and same for rectangle?
the scren shot shows a very small set of the data, but what I need to happen is to allow the user to choose square, and have it pull up part numbers, 44444, 55555, and 22222.
I'm guessing I may need to create a seperate column for this, but am uncertain how to do that..
thank you in advance.
Assume your table with the A B columns is named "data".
types:
LOAD DISTINCT
B,
'Square' as Type
RESIDENT data
WHERE B LIKE '*square*'
;
LOAD DISTINCT
B,
'Rectangle' as Type
RESIDENT data
WHERE B LIKE '*rect*'
;
The second LOAD is not necessary if you don't need to set a type for Rectangle as well.
-Rob