I use the following to generate a popup window of a list a STANDARDS that are in a separate form called STANDARD SPECS:

STR1=@XLISTVALUES(@fn,"STANDARD SPECS!STANDARD")

Further programming allows me to select and view the standard.

This works well as is, but it only provides me a list of the names of the STANDARDS.  I now have a need to list both the STANDARD and the REVISION of the standard.

What is the best way to list both elements?

Thanks, in advance, for your help.

NHUser

It seems that the @XLookupSourceListAll is finding all records that match a key; in your example FL.  I don't want to find only certain records, I want to display ALL the records.

So, rather than setting a key of FL, how do I force it to send me the info for ALL the states?

I found the ".." key works, so now I'm getting the data I need.  However, the sort and list programming is not working properly.  My programming is this:

VAR STR1 AS STRING
VAR STR2 AS STRING
var vTemp as Int



PopupSelectPosition(4, @XPos(ThisElement), @YPos(ThisElement))

// STR1=@XLISTVALUES(@fn,"CUSTOMER SPECS!CSPECS")

STR1=@XLookupSourceListAll(@fn,"..","CUSTOMER SPECS!CSPECS","CSpecs;Revision")


STR1 = @SORTSTRINGARRAY(STR1, 0)


STR2=@PopupChoiceList(STR1,"SELECT A SPECIFICATION")

     If @Len(STR2) > 0
     {
           vTemp = @ASynchShell("F:\Sesame docs\ts doc Customer Specs\"+STR2)
     }

When I run this programming, the sort is messed up and the display window shows only one column of data (should be two).  Then when I scroll down, the bottom half of each line disappears!  See the attached.

Help!

Hey, BOBSCOTT

Your suggestion works!!

Thanks for the help!

NHUser

How about before running your  vTemp = @ASynchShell("F:\Sesame docs\ts doc Customer Specs\"+STR2)
hack everything from the tilde on off. you could use something like


     var vPos as Int

     vPos = @Instr(str2, "~")
//writeln(vpos)

Str2 =  @LEFT(vdata, vpos - 1)

vTemp = @ASynchShell("F:\Sesame docs\ts doc Customer Specs\"+STR2)