I am trying to combine two external fields to pop up on the same line so that the user can choose the appropriate vendor where their are similar vendors but different references.

For example: Supplier A with a reference of RRSP.  The same Supplier A with a reference of Group Benefits.  Same supplier but different vendor #'s.

I have currently have a combo box that populates with the following programming:

var vList as String


vList = @XListValues("VENDORS.DB", "VENDORS!VENDOR NAME") + @XListValues("VENDORS.DB", "VENDORS!REFERENCE")
vList = @SortStringArray(vList, 0)                  //0 = ASCII sort, 1 = Number sort
PopulateListElement(vENDOR NAME, vList)


Unfortunately, it lists all the available Vendor Names and all the available references in alpha order instead of:

Supplier A - RRSP
Supplier A - Group Benefits

Is their a way to do this ? I tried to modify the statements but with no luck.

Thanks,

Louis

Ray:

It works but it returns both the vendor name and reference.    The reference is only required for selection purposes.

I am sure you have more ideas.

Thanks,

Louis

Ray:

I am having a heck of a time with the programming.

My programming now reads:

var vList as String
 
 
vList = @XLookupSourceListAll("VENDORS.DB", "..", "VENDORS!VENDOR NAME", "VENDOR NAME;REFERENCE")
vList = @Replace(vList, ";", " - ")                        // replaces ;separated values with a " -  "
vList = @Replace(vList, @Newline(), ";")                  // inserts newline in list
vList = @SortStringArray(vList, 0)                        //0 = ASCII sort, 1 = Number sort   
PopulateListElement(VENDOR NAME, vList)   
Vendor Name = @LEFT(vList, @INSTR(vList, ";") -1)

Unfortunately, it is still returning the entire value including the dash and it is really everything before the dash.  I have tried inserting the dash in lieu of the ; but to no avail.

Any suggestions before lunch ?

Thanks,

Louis

Ray:

How do I strip this away ? 

It is no longer a semi-colon separated string and  @Left needs a value to determine where to end.

I have tried the INSTR as well but with no luck.

Any hints ?

Thanks,

Louis

Hello Louis,

You would use @InStr on ' - ', without the quotes, and you would want the value to the left of the ' - '. Do this in the On Element Change Event.

-Ray