Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Field 'PartNumber'. I have separated 'PartNumber'' into 2 types. by Use code.
TEST:
load PartNumber,
if(WildMatch(if(IsNum(left(PartNumber',1)),mid(PartNumber',7,1)) ,'M','D'),PartNumber') as ONETYPE,
if(WildMatch(if(IsNum(left(PartNumber',1)),mid(PartNumber',7,1)) ,'A','B'),PartNumber') as TWOTYPE
where XXX;
But
I want to make a Listbox 'Type' where in the Listbox there are two values: ONETYPE and TWOTYPE
to select a category type.
This is the wrong board for this question. You posted the same question also here and that's a better board. Please don't post questions in multiple boards.