help... How to create seperate column for user selection

[chadsherk]

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. 

[rwunderlich]

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

http://robwunderlich.com